ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   How do I link Excel pages to a different master Excel workbook? (https://www.excelbanter.com/new-users-excel/192036-how-do-i-link-excel-pages-different-master-excel-workbook.html)

Zaydrin

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.

Dragonomega

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