View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
George[_3_] George[_3_] is offline
external usenet poster
 
Posts: 14
Default 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