Linking Data from one spreadsheet to another

[Kdhowery]

I would like to have the data in a cell in one spreadsheet, link to another spreadsheet automatically. How do I do this?

[ben_hensel]

Do this with an external reference.

General synax:
A1 = [spreadsheetName.xlsx]sheet1!A1

You might need to stick the file extension on:

A1 = 'Drive:\FolderPath\[spreadsheetName.xlsx]sheet1'!A1

Be aware of those single quotes - I can never remember exactly how to get them to work so I usually have to mess around a little bit to get it to work.

Well, if you have both locations equal, you can just type "=" and then go click on the target cell just like you would if it was a different cell on the same worksheet, and then excel will automatically parse the path.

You can link ranges, like A1:B5 instead of just single cells, or do an operation, like
A1 = SUM('Drive:\FolderPath\[spreadsheetName.xlsx]sheet1'!A1:B5)
or whatever.