Connect 2 Google spreadsheets to share data between them.

Asked By user123 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

• Status: Open
• Question Views: 517
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Internet

Answered By Keith Riley 5 points N/A #199378

Connect 2 Google spreadsheets to share data between them.

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)

 

About Keith Riley

Questions
0

Answers
100

Best Answers
26

• Vote Up 0 Vote Down

• Posted on - 11/18/2013
• Question Category: Internet