Excel workbook links

  • Thread starter Thread starter Tuck
  • Start date Start date
T

Tuck

Is there a way to link a specific worksheet in a workbook to a different
workbook? I have a summary workbook that links to separate job workbook. Each
job workbook has multiple worksheets. I want the first worksheet in each job
workbook to be linked to a summary workbook. The summary workbook will have a
worksheet for each linked job first worksheet. Does that make sense?
 
You want to link all the cells in a worksheet to cells in another worksheet
in another workbook?

Select the source range, say A1:Z100, Copy the range
Go to the cell A1 in your destination sheet and choose Edit->Paste
Special->Paste Link
 
Back
Top