Hi all
I wonder if someone can help me out.
I have sequential dates on row 14 (horizontally) from column M to column IV ( e.g. 01/11/2011, 02/11/2011, 03/11/2011, 04/11/2011, 05/11/2011, etc...). Now I would like to achieve a macro or formula that would populate the data on row 13 (again from column M to column IV). It should look 1 cell below and if the date happens to be the first of the month then it should populate the value of the month, if its not the first of the month then leave cell empty. Let me illustrate below:
Before macro/formula:
Row 13 -- -------------------------------------------------------------------------------------------------------------------------------------
Row 14 -- 01/11/2011 -- 02/11/2011 -- 03/11/2011 -- etc… -- 01/12/2011 -- 02/12/2011 -- 03/12/2011 -- etc…
After macro/formula:
Row 13 -- November------------------------------------------------------December--------------------------------------------------
Row 14 -- 01/11/2011 -- 02/11/2011 -- 03/11/2011 -- etc… -- 01/12/2011 -- 02/12/2011 -- 03/12/2011 -- etc…
I have attached spreadsheet that includes sheets "Before" and "After"
I would appreciate if someone can help me with this.
Cheers
Bookmarks