Hi,



It's no problem that you're new to this - we're here to help. Rather than give you the answer, I'll ask you a question because I think it'll help you understand what the problem is: in your code, what is Data?

Hi Colin,
The Data comes from a calendar. It is a list of mailing that we do. I designed a input screen that mailings can be put into and then each day is linked to a calendar to be reviewed by a few vendors and staff. The information I gave you is just one vendor. I need to pastevalue to the sheet I showed you and then sort it so it will appear on the calendar in order.
I have attached an example of the end result I'm looking for.
I want to get rid of the spaces and have everything go to the top.
Hope this explains it. The origional file is over 11 MB so I can't send you the whole workbook.
Thanks