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