Copy and Paste dates then chnage the format to show the month

[spiritbarbie]

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

[nickmax1]

sample please!

[spiritbarbie]

hope the attached works, I've just cut a section of the sheet regarding the date month issue as there is some info I can't share I'm afraid

[nickmax1]

just use this formula in D2 and copy/paste it down

=TEXT(C2,"mmmm")

[spiritbarbie]

I was hoping to automate the process of inserting cells and formulas as this is a long data set which I have to work with every week, is that possible?

[nickmax1]

I dont understand what you mean. If you drag the formula down then it will automatically give you the month for whatever is in Colomn C.

You could make it look prettier by having this instead =if(c2="","",TEXT(C2,"mmmm")) and drag that down to as long as the dataset could ever be.

[nickmax1]

or post your code for inserting cells/formulas and will see what can be done.