Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.links
|
|||
|
|||
![]()
I am using winxp pro and msoffice 2003
I have a workbook containing many vendor sheets. It is the master pricing workbook. I also have customer workbooks each containing a copy of the master pricing spreadsheet for any vendors the customer uses. I want to link the customer sheets to the master pricing sheets so when pricing is updated in the Master, all the customer pricing spreadsheets also get updated. I created the customer spreadsheets using copy/past from the master so that they would be identical. My question is: Can I link the pricing level column in the master sheet to the pricing level column in the customer sheet by linking the entire column (maybe using a range formula/command?) or must I link the cells in the columns individually. I've never done this type of work before, so if I am going about this totally wrong, please feel free to straighten me out. I am open to all suggestions and advice on how to get this project up and running. Thanks so much for your time and effort. This is a great place to go to get advice and answers before spending a lot of time doing things wrong and then having to re-do them. (Learned my lesson well about that ;-)!) Joanne |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Linking columns in separate worksheets | Excel Discussion (Misc queries) | |||
Linking data between columns in an automatic way with dynamic link | Excel Discussion (Misc queries) | |||
linking columns | Excel Worksheet Functions | |||
Linking between multiple worksheets, workbooks and columns | Excel Discussion (Misc queries) | |||
Linking Columns and cells | Excel Worksheet Functions |