I use the Sharepad "live" tables in Google sheets
My Google sheet has a Sharepad worksheet & I use lookup functions to reference that from other sheets
This works fine until I want to add something to the Sharepad live table.
Then I need to create a new live sheet, upload it to google, copy or import to my working google sheets, delete the original "Sharepad" worksheet, rename the new one as "Sharepad" and fix all the broken lookup functions. It's particularly annoying that the lookup functions break, when I have kept the sheetname which the lookup functions use.
Is there a faster way to do this ?
Cutting and pasting into the existing live google sheet doesn't seem to work.
I'd even settle for something that doesn't break the lookup functions.
Google doesn't give the option to import into the existing Sharepad sheet.
Got a credit card? use our Credit Card & Finance Calculators
Thanks to niord,gvonge,Shelford,GrahamPlatt,gpadsa, for Donating to support the site
Google Sheets & Sharepad Live Table
-
- Lemon Pip
- Posts: 84
- Joined: November 7th, 2016, 8:54 am
- Has thanked: 11 times
- Been thanked: 27 times
Re: Google Sheets & Sharepad Live Table
Even if I have a sheet with lookups from other providers such as Yahoo etc deleting one line screws up or the refences on other sheets. Absolute pain that I've not found a solution to either!
Return to “Financial Software - Discussion”
Who is online
Users browsing this forum: No registered users and 6 guests