Linking worksheets

[Joanne]

I am using winxp pro and excel 2003
I have a master workbook that contains a worksheet for each vendor.
The worksheet has the various 'levels' of pricing on them.

I want to create workbooks for each customer that contain a copy/paste
of the worksheet containing the vendor info in the master workbook for
each vendor the customer uses (and containing only the column that has
the customer's 'level' of pricing info in it). Copy/paste guarantees I
will create them exactly the same as they are in the master workbook.

Pricing changes are made on the Master workbook. I want to link them to
the individual worksheets in the customer workbooks.

My question is can I link an entire column, or must I link cell by cell
to keep the customer worksheets in sync with the master.

Thanks for your advice. It is always great to come here and get a good
idea of what I am doing before putting in a lot of time and effort in
only to find out I am barking up the wrong tree!!

Joanne

 

[Jean-Guy Marcil]

Joanne was telling us:
Joanne nous racontait que :

I am using winxp pro and excel 2003
I have a master workbook that contains a worksheet for each vendor.
The worksheet has the various 'levels' of pricing on them.

I want to create workbooks for each customer that contain a copy/paste
of the worksheet containing the vendor info in the master workbook for
each vendor the customer uses (and containing only the column that has
the customer's 'level' of pricing info in it). Copy/paste guarantees I
will create them exactly the same as they are in the master workbook.

Pricing changes are made on the Master workbook. I want to link them
to the individual worksheets in the customer workbooks.

My question is can I link an entire column, or must I link cell by
cell to keep the customer worksheets in sync with the master.

Thanks for your advice. It is always great to come here and get a good
idea of what I am doing before putting in a lot of time and effort in
only to find out I am barking up the wrong tree!!

Joanne

This group is for those having questions regarding basic Word VBA
programming...

You should ask in an Excel group.


--

Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org