Create a row that is a group header for grouped rows by date

[mramey64]

I have a worksheet that has anywhere from 100 to 200 line items. My user can enter a new "Job" on the first open row by entering a job number column K and version number in column L. On the on change event I have code that reaches out to a SQL Server database and grabs related data and fills in other cells on that row for the job. It works great. One of the cells has a "Drop Date" column that holds a date. I have another macro that sorts these jobs by 1. Column A "Priority" (1,2,4,5) and the "Drop Date" column next.

I need to have that macro create a "Group Header" row that displays a Long Date for all the Jobs below it matching that date. In other words Row 17 may have a cell that reads "Thursday, November 07, 2012" and that row is shaded light blue from column A to column AG. Then all the jobs with a drop date
of November 7 will be grouped under that "Group Header Row" sorted by Job #. Then the next group of jobs may drop on November 8 so there needs to be a "Group Header Row" displaying that Long Date.

Can anyone help me with the macro to do this? I have attached a screen shot of what it looks like but it was done manually.

thanks!

Mike