Change column reference to next column dependent on date
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?
Re: Change column reference to next column dependent on date
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1