Linking Data Between Multiple Files

  • Thread starter Thread starter Guppy
  • Start date Start date
G

Guppy

I need to have a main excel file that will look up information in othe
excel files. The secondary excel files will be created monthly and th
main file will cover the overall yearly statistics.

I would like to create all the worksheets in the main file at once s
that as the monthly files are created the information is automaticall
put in. When I do that Excel complains that it can't find the files
Anyway around this?
 
Hi Guppy

If all of the sheets are identical, including the yearly summary, one way to
do the job is to have a sheet at the beginning (Start) and one just before
the yearly one (End).
Using this formula (copied across and down) the sheet will update as you
input the monthly info.

=SUM(Start:End!A1)

Andy.
 
Back
Top