Linking Worksheets to different Work Books

  • Thread starter Thread starter Kimberly Lay
  • Start date Start date
K

Kimberly Lay

I am trying to link a worksheet out of one workbook to
another workbook. I want to link the entire worksheet, so
the second file is always updated with the current
information. Is there a way to do this with out having to
put an individual formula in each cell?
 
You can use Data, Consolidate. However, it does not give you immediate
updates. You will need formulas for that.

David Hager
Excel MVP
 
Back
Top