Search & replace function

A

Angie B

I have many excel spreadsheets containing various price lists. When I want to
make a change to an item on the price list, I have to go to each and every
spreadsheet individually that contains the item and make the change manually.
Is it possible to use the search & replace feature to automate this task?
 
B

Bernie Deitrick

Angie,

No, you would need to use a macro.

But, instead of using a price list in every workbook, you should use one workbook with a master
price list and either 1) have all your other "price lists" link to that one master price list or 2)
use the mater price list in all your formulas.

HTH,
Bernie
MS Excel MVP
 
Top