Hi,

I have a spreadsheet which I have been spending time on each month inserting rows and formatting and I am trying to automate as much of that porcess and possible, I have already created a macro to insert and rename the columns I need. What I now need is to populate the 'month' column, I have a columns with the date and time of the activity and what I want to do is show the month of this date in my new column. I tried copy pasting and formating the cells but the date is still there behind the month text which cause problems when I try and use the data in pivot tables.


hope that makes some kind of sense!

Any suggestions would be great