Choosing between actual & budget data

[niraj]

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

 

[Jim Thomlinson]

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...