Excel workbook links
 

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?

Excel workbook links
 

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
-------------------------------------
Pl. click ''Yes'' if this was helpful...