Formulas
Hi Guys, got a problem here that hope you can solv
Currently, i have to update my database formulas monthl What is currently happening is that i entered a formula to read data from a monthly source file. So, at every month end, i have to change the formula manually so that the new month's source data could be read The formula is not for a single worksheet page only, it is the same formula used for many worksheet pages For example:the formual bar shows =$C$1......December..... SO every month, i have to to change the month, like december to january. I understand we can use the find/replace function, but that works only for each colume at a time, thus I have to update every column manually using the replace function. Sometimes if the formula exist in many pages of the workbook and and manytimes in the columns of the worksheet, i have to take a long time to update I want to create a formulae that enable me to update the months(formula) on every colum and every worksheet in the workbook at a click of a button Is there anyway to create a formula or a Macros so that i do not have to update all the formulas manually, but rather, by pressing the Macros icon,or by some other means, the formulas can be updated? Pls hel Thanks |
All times are GMT +1. The time now is 10:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com