ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Updating formulas on workbook (https://www.excelbanter.com/excel-discussion-misc-queries/206585-updating-formulas-workbook.html)

Byron720

Updating formulas on workbook
 
How do I change a formula from Oct 08 to Nov 08 in different worksheets all
at once? Example change Oct 08! reference in all formulas to May05! in all
worksheets at once. The workbook contains many worksheets and it takes time
to go thru each page and change it.

Byron720

Updating formulas on workbook
 
I found out how to do it. In case someone needs to know, just select all
worksheets and do a find a replace

"Byron720" wrote:

How do I change a formula from Oct 08 to Nov 08 in different worksheets all
at once? Example change Oct 08! reference in all formulas to May05! in all
worksheets at once. The workbook contains many worksheets and it takes time
to go thru each page and change it.



All times are GMT +1. The time now is 11:35 PM.

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