| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Choosing between actual & budget data
I have two sheets, one for actuals (as they happen) and one for budget data.
I have another sheet which shows actuals to date (by month) followed by the budget data for the remaining months. Is it possible to create a macro/function to pick up either actual or budget depending on the month? This saves me rolling forward the formulaes within the previous month I have thought of doing if via an if statement, but I don't really want to have an if statement in every cell thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Choosing between actual & budget data
Macros are more of a solution of last resort. The If statements will be a
whole pile cleaner and much easier to audit if something goes wrong. The overhead to using the if statements is minimal. If you are worried tht the if statements will take to long the macro will take longer... -- HTH... Jim Thomlinson "niraj" wrote: I have two sheets, one for actuals (as they happen) and one for budget data. I have another sheet which shows actuals to date (by month) followed by the budget data for the remaining months. Is it possible to create a macro/function to pick up either actual or budget depending on the month? This saves me rolling forward the formulaes within the previous month I have thought of doing if via an if statement, but I don't really want to have an if statement in every cell thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Percentage Difference Between Budget & Actual | Excel Discussion (Misc queries) | |||
| Compare budget to actual | Excel Discussion (Misc queries) | |||
| Labor Costs Budget to Actual | Excel Discussion (Misc queries) | |||
| Budget vs. Actual | Excel Discussion (Misc queries) | |||
| YTD Budget Sum if Actual Month has activities | Excel Worksheet Functions | |||
Linear Mode
