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?




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

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