Drawing data between spreadsheets

[chrisjread]

Hi,

I've got three spreadsheets with info over different tabs which are to be posted onto a shared drive. I also want to create a fourth spreadsheet which will also be on the shared drive which will draw information from the other three. I know how to pull info between tabs on the same spreadsheet - 'tab_name'!C4:C8 etc, but not how do do it from different .xls files.

The 3 spreadsheets are also on my harddrive so I can create the 4th on my laptop before posting to the shared drive.

Any help would be appreciated,

Thanks

Chris

 

[Andrew Poulsom]

Open the source and the target workbook. In a cell in the target workbook type equals, click Window on the menu and select the source workbook, point at the cell whose value you want and press Enter.

That will give you the syntax. Note that external references created like this are always absolute. If you want to copy the formula you will need to remove the $ before column or row, or maybe both.

 

[chrisjread]

Great,

Thank you Andrew, very helpful!