Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Search and open excel workbooks from a master workbook | Excel Discussion (Misc queries) | |||
Link a Master Template Excel file to different excel source files | Excel Worksheet Functions | |||
Master Excel workbook | Excel Discussion (Misc queries) | |||
how to create a list and link it to the master excel file | Excel Worksheet Functions | |||
HOW DO I LINK PAGES ON EXCEL TO FOLLOW SAME LINKED FORMULA? | Excel Worksheet Functions |