S
Shane
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
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