Group cells by dates (months)

Hi, I have a list with two columns; names and dates. I want to group names according to months. I can make it with pivot but is there any way to do it wiht a macro. Please see attachment.

Thanks..


sample date.xls

Try the attached.

Please Login or Register  to view this content.

Thanks jindon that’s great but can I ask one more favor, I want to change color of cells by types. I tried to modify your code but I couldn’t make it please see attachment.

sample date2.xls

Try change to

Please Login or Register  to view this content.

Thank you jindon, it works like charm

If that takes care of your original question, select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.