linking spreadsheets

Hello Everyone, Each week, I create a spreadsheet, containing data and the file name is based on the week in question. With each spreadsheet, I have formulas linking back to the previous week to compare week over week. The formula looks as so: =SUM('T:\[STOCK, April 24 to April 30...

Hi all, I am trying to set up a financial accounting system that involves linking a central spreadsheet to various source spreadsheets (salaries, receipts) in different Dropbox folders. This is simple enough when working from my own computer, but the system needs to be accessible and editable...

Happy Friday! I've got a large spreadsheet (4k rows) of contacts who have standard columns with addresses, emails etc. AND all have the country where the contact is located. Every single entry has this value. I want to make three spreadsheets for global regions (Europe, North America, ROW)...

I have a custom data entry form defined in one spreadsheet that I would like to have populate another spreadsheet that is in a typical database format. The data in the custom data entry form uses data validation to control what the user can select for some of the fields. So the built-in data...