Dear Experts,

In a workbook in all worksheets D1 has Month Last Year and E1 has Month This Year.

Eg.
Sheet 1 cell D1 contains ‘Jan-13 cell E1 ‘Jan-14
Sheet 2 cell D1 contains ‘Feb-13 cell E1 ‘Feb-14
We have 13 sheets (12 months and one total sheet)

What I want to do is

For each worksheet in the workbook

Insert column A
A1 .value = Month
All other rows in column A pick up the month from D1 of respective worksheet Eg Jan or Feb…..
Change D1 to 2013 iso ‘Jan-13 and Change E1 to 2014 iso ‘Jan-14
Best Regards/VKS