linking columns
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 |
All times are GMT +1. The time now is 03:18 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com