ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   port formula changes to multiple workbooks? (https://www.excelbanter.com/excel-discussion-misc-queries/150971-port-formula-changes-multiple-workbooks.html)

George[_3_]

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


All times are GMT +1. The time now is 02:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com