![]() |
How do I link Excel pages to a different master Excel workbook?
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. |
How do I link Excel pages to a different master Excel workbook?
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 "Zaydrin" wrote: 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. |
All times are GMT +1. The time now is 08:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com