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?