I am using excel 2003 to keep up with a company's pricesheet. There is a
list of all the materials that go into the final producton the first sheet
called the MASTER PRICE LIST, and then several sheets that list different
product configurations and the final prices. I would like to be able to
change the price of the material on the first sheet and it automatically
adjust the price of all the final product configurations that use that
material. I can use the formula ='MASTER PRICE LIST'!** where ** equals the
cell number the price is in, but this is a large workbook and it would take a
long time to input the formula one cell at a time, is there any way to change
all the cells that list the price of a certain material at once, even if they
are located on multiple sheets?

if you do actually link the prices back to the master price list they will
all change when you change the master prie book,however this can have
drawbacks esp if have quote sheets looking back at the prices and then you
have a price change.......You can do a find and replace on each sheet......
--
paul
remove nospam for email addy!



"marcusamcspadden" wrote:

I am using excel 2003 to keep up with a company's pricesheet. There is a
list of all the materials that go into the final producton the first sheet
called the MASTER PRICE LIST, and then several sheets that list different
product configurations and the final prices. I would like to be able to
change the price of the material on the first sheet and it automatically
adjust the price of all the final product configurations that use that
material. I can use the formula ='MASTER PRICE LIST'!** where ** equals the
cell number the price is in, but this is a large workbook and it would take a
long time to input the formula one cell at a time, is there any way to change
all the cells that list the price of a certain material at once, even if they
are located on multiple sheets?