Excel Formulas

[Guest]

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

 

[Paul B]

Shane, how about put your month in a cell and referencing that cell in your
formula, then you would only have to change that one cell something like
this =$C$1......$A$1...... would that work for you?
--
Paul B
Always backup your data before trying something new
Using Excel 97 & 2000
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **

Hi Guys, got a problem here that hope you can solve


Currently, i have to update my database formulas monthly

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.