How do I link Excel pages to a different master Excel workbook?

Z

Zaydrin

I am trying to take part lists from different assemblies and link them to a
master part list. Ideally one sheet from the assembly part lists will have
many pages and be linked to a sheet in the master part list with the name of
that specific assembly.
I am operating on Midrosoft Office Version 2003.
 
D

Dragonomega

open both the master and your part list on your master if you set a cell to
(="name of part list book"!A1) you can do that by clicking any cell on the
other workbook with them both open its just like a formula on the sheet only
instead it has the workbooks name first i hope this helps as this is how i
understood the question if i am wrong please tell me and i will try to help
further
 

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

Embed the same Excel multiple times 0
External cell reference between two excel worksheets both in One Drive 0
Excel linking from one master worksheet to many worksheets and ableto return a value back. 0
Loosing transparency effect of Master Page graphic when Saving Publisher files as .pdf 0
How do I link a cell in a workbook? 1
linking sheets and workbooks 0
How to update data from linked worksheet back to a master worksheet? 0
How to update a value from a linked worksheet back to the master worksheet? 0

Top