Hi,

I have a spreadsheet which is a monthly financial report, and there is a figure it brings in from another worksheet which is the corresponding figure for that month from the previous year.

So currently the formula is simply this: ='LY Figures'!BH61
For the next month, I need it to be ='LY Figures'!BI61
So the column has simply moved over to the next one. There are a range of cells that all refer to ='LY Figures'!BH## - different rows each time.

What I want to do if possible, is automatically change the column reference, leaving the row number alone, dependent on the date.

So if the current month = 5, then BH.... if month = 6 then BI and so forth.
I can do an IF function in VBA, but I don't know how to change the column reference.
I preferably want to change all references of BH to BI, not cell by cell.

Is this possible and how do I achieve it?

Thanks,
Michael