Connect 2 Google spreadsheets to share data between them.

Asked By 0 points N/A Posted on -
qa-featured

Connect 2 Google spreadsheets to share data between them.

Can i have real examples shared to share between docs sheets

SHARE
Answered By 5 points N/A #199378

Connect 2 Google spreadsheets to share data between them.

qa-featured

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)

 

Related Questions