Hi all,

I have the attached spreadsheet.

Sheet 1 contains the current data I have. Sheet 2 contains how I wish to have presented with the help of a macro.

Basically I want the data to be grouped by CPT ID, after the grouping, I want the data to be sorted by the STD earliest to latest, whilst maintaining the grouping.

You will see in Sheet 2 the difference.

Data will be completely different each day.

Look forward to the help.

Thanks
Hayden

fltdata.xlsx