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