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

  • Thread starter Thread starter Zaydrin
  • Start date Start date
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.
 
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
 
Back
Top