VBA to sort and group data together
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
Pl see attached file with Macro.
If you first sort your data by STD and then by CPT ID (both times asending) you will get the lay out you wish. A short macro for doing so could be written perhaps like this.
If you just wish to sort your data on Sheet1 and not copy result to Sheet2 remove lines marked ' remove not needed
Please Login or Register to view this content.
Alf
Last edited by Alf; 04-07-2014 at 07:42 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks