Linking two spreadsheets

I am trying to link two spreadsheets. One spreadsheet I have I am wanting to update weekly based on the information that is created in a seperate spreadsheet by a report I run.

The spreadsheet that I am wanting to update weekly will have a column with notes and misc information that will not be a part of the spreadsheet that is created weekly.

I am wanting to somehow link the two spreadsheets to keep me from having to continually copy my notes from the previous week to a spreadsheet for the current week.

Any pointers or suggestions will be greatly appreciated.

You could use the Vlookup formule to get info from your other files

Make a table with the information to be retreived in 'my_other_file' and name it 'my_list' In the first column make an index list

Then in your weekly report use a formula like

=VLOOKUP(A1;'C:\your_other_file'!your_list;X;0)

You may want to use the excel helpfile about explanation of the vlookup formula.

A1 is the reference in your report corresponing to the first column in your_list
For C use 1..99 for the columnnumber where the info is that you need.

Good luck.

Arien

Thanks for the info, let me play with it.