Macro to generate month

[akhileshgs]

Hello All,

I am searching for a macro which will add the month in 'mmm' format in in column B from B6 till last row of data filled in C column.
Attaching the imagefor your quick understanding.

The yellow highlighted is the desired macro generated field

Thanks in advance
Snap1.jpg

[teylyn]

Hello,

why do you want a macro? You can use this formula in cell B6:

=Text(C6,"mmm")

and copy down.

cheers, teylyn

[akhileshgs]

Hello,

why do you want a macro? You can use this formula in cell B6:

=Text(C6,"mmm")

and copy down.

cheers, teylyn

Hello
Thanks for the reply
I thought about that. But if I put the formula in the entire column, the size of the file is getting increased from 50kb to 8mb. That's why

[Crooza]

As a macro

Please Login or Register  to view this content.

[akhileshgs]

Your code is working perfectly. Thanks