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
 

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 Copy cells from one worksheet to another workseet - increment row & do again 0
Linking a workbook to worksheets 1
Linking data from one worksheet to another... 2
Sorting Linked Data Between Sheets 3
Excel Move or Copy Stopped Working? 0
worksheets equaling other worksheets 1
want to create a link to another worksheet in another workbook 1
Link cells with text not numbers 4

Back
Top