Selecting once cell to the right

[Vidhur100]

Hi

I have a workbook that contains a monthly P&L account
I want to run a macro that rolls the report forward one month

One of the sheets (called say Sheet2) contains the prior year P&L month by month

EG
Col D has April 13 figures
Col E has May 13 figures

Another sheet (called say Sheet1) contains the current months figures compared with the same month for last year
ie Col A has April 14 and Col B April 13

When I run the macro to roll the month I want to replace the figures in Col B on sheet 1 (which currently contains the contents of Col D in sheet2) with the figures of Col E in sheet2 (ie one to the right)

Thanks
Vidhur

[Richard Buttrey]

Please upload the workbook.

[Vidhur100]

See attached

So when I run the macro I would like the data in sheet1 col E to pick up the data in sheet2 col E
And when I run it again next month I would like the date in sheet1 col E to pick up the data in sheet2 col F

And so on

Thanks
Vidhur
P&L Account Test Data.xlsm

[Richard Buttrey]

Hi,

See attached. It doesn't need a macro. The formulas adjust when you change the Sheet 1 D2 cell to the month end date.

[Vidhur100]

That's so clever
Thank you