Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert Array Formulas to Regular Formulas | Excel Worksheet Functions | |||
Convert Array Formulas to Regular Formulas | Excel Worksheet Functions | |||
Counting # of Formulas in a column with formulas and entered data | Excel Worksheet Functions | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) |