Data Sorting to a Specific Format

[vnzerem]

The code below sorts data for me but I will need a modification so as to achieve my new goal.
From the attached spreadsheet, the first tab called “data” is the data that I want to sort in a particular format. The second tab called “Results” is what I sorted already with the old code, while the third tab “Preferred” is the actual thing that I need.
This is what I need:
Whenever the macro meets a cell that has no value in it, it should replace the blank cell with “1*” also whenever the macro meets a cell that has the same date (as you can see that the orange cells have the same date as the gray rows), instead of outputting the result as shown in “Results” tab, I want the macro to combine these rows as shown in the “preferred” tab.
Also you can see that the yellow cell has the same date as “1-Feb-07” I will like to combine it as shown in the preferred tab.
Thanks a lot for your help.
Below is my code:

Please Login or Register  to view this content.

[davesexcel]

you could use a filter macro instead, click the button and then check out results sheet.

edit the code to suite your requirements.

Checkout the attached.

Please Login or Register  to view this content.

[vnzerem]

davesexcel...thank you so much for your solution, but the code does not give me exactly the format specified in the "preferred" tab of the spreadsheet. The preferred tab is what I am looking for.

[davesexcel]

Please read the second line of my previous post.

My code shows you how to get the data to the next sheet, edit the code to format it the way you require.

[vnzerem]

thanks a lot davesexcel....I missed the second line and jumped straight to the code. I truly appreciate this. It is really thinking outside the box. I will proceed and modify your code to suite my needs. Thanks once more for your time and have a wonderful day ahead.

[vnzerem]

davesexcel:
Thanks so much for giving me the foundation to write the code. Below is the code I was able to achieve by modifying your code and it worked out great. I appreciate the help!

Please Login or Register  to view this content.