Thread: linking columns
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.links
Joanne Joanne is offline
external usenet poster
 
Posts: 121
Default 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