Linking workbooks

  • Thread starter Thread starter Fawn
  • Start date Start date
F

Fawn

I have 4 workbooks with approximately 12 sheets with the information rolling
up into one YTD sheet. What I want to do is to have all 4 of the YTD sheets
on a master recap. All the information will be coming to me by email from
all different users. Is it possible to have all this information
automatically link into the master recap or would I have to manually type it
in.

Any help would be appreciated.

Thanks
 
I have 4 workbooks with approximately 12 sheets with the information rolling
up into one YTD sheet. What I want to do is to have all 4 of the YTD sheets
on a master recap. All the information will be coming to me by email from
all different users. Is it possible to have all this information
automatically link into the master recap or would I have to manually type it
in.
Click to expand...

If you just want to sum, count, average or the like across all of these
workbooks, Data > Consolidate would make it relatively painless if all of these
files were in the same directory. If you want to pull values from each of these
files individually, there's unavoidable work involved.

If all the files had similar filenames, see the first alternative in the article
at this link.

http://www.google.com/[email protected]
 
Back
Top