Script or Macro to change IF statements on multiple Excel Spreadsheets
Posted on 2011-09-18
We have multiple spreadsheets containing data. Each Spreadsheet is configured in the same format i.e columns are the same. Some of the cells contain IF statements.
Upon analysis, we have found that some of these IF statements require correction. Is there anyway I can edit these if statements across multiple spreadsheets with out having to open each work book and edit it?
Any pointers would be appreciated.