Connect 2 Google spreadsheets to share data between them.
Asked By
0 points
N/A
Posted on - 11/17/2013
Connect 2 Google spreadsheets to share data between them.
Can i have real examples shared to share between docs sheets
Connect 2 Google spreadsheets to share data between them.
Can i have real examples shared to share between docs sheets
Hi!
This is one complex solution for your problem.
Steps are written below:
1. Firstly, look at URL format.
2. Then, now please look at this example of URL spreadsheet.
3. After that, according to its URL, you'll see 'key=' and '&hl='.
4. A long combination between those two words is the key.
5. Next, use ImportRange. The purpose is to make as reference to the spreadsheet.
6. Example of format is =ImportRange("KeyName";"SheetName!FirstCell!LastCell)
Â