port formula changes to multiple workbooks?
I have multiple instances of the same basic workbook - each with
different data sets, but the same cell formulas and VBA code. If I
change some formulas, is there a simple way to port the changes to these
other workbooks, without disturbing their data? No cell locations are
changed, no cells added, ... just changing some equations.
(I believe I could go to each sheet, Select All, and then
'Paste_special.Formulas', etc. I'm hoping there's a less tedious
method.)
Thanks,
George
|