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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Columns moving up and down on their own in a worksheet. What Goes? 2
dynamic data copying between worksheets 0
Creating multiple workbooks 5
Creating a template that I can reproduce every month by keying ininformation from SAP 8
Multiple sheet querries 4
Import external data link disappears 1
IF formula? 1
Auto update worksheets 2

Back
Top