Hi,

I have a spreadsheet with months and figures across columns, i.e:

July;August;September;October...
62000;45000;23000;56000...

Assuming dates start at A1 and figures at A2.

The figures are either pulled as actuals (from an actuals sheet) or budget (from a budget sheet) for a rolling forecast. I have a cell (I6) that updates the current date when you open the workbook. My question is - how can I create a formula that pulls actuals figures in upto the current date, and budget figures for the remaining months. This would obviously automatically move forward automatically based on the month in cell I6.

Thanks in advance. Let me know if you require any further details.