I need assistance in writing a formula to complete a monthly analysis report.
Let me try to explain what I want to do.
I have a workbook where I analyse variance monthly and YTD. Each month I would manually update the Current month column in my formula. But I need a formula for that will pull the data from the various worksheets by me just inserting the Current Month in Cell (L2).
So, I have in cell (L2) the Current Month.
Therefore, SUM(OFFSET(Actual!$D7,0,0,1,MATCH($L$2,Actual!$D$4:$O$4,0))) - works for the YTD.
Any suggestions, please?
Let me try to explain what I want to do.
I have a workbook where I analyse variance monthly and YTD. Each month I would manually update the Current month column in my formula. But I need a formula for that will pull the data from the various worksheets by me just inserting the Current Month in Cell (L2).
So, I have in cell (L2) the Current Month.
Therefore, SUM(OFFSET(Actual!$D7,0,0,1,MATCH($L$2,Actual!$D$4:$O$4,0))) - works for the YTD.
Any suggestions, please?
