I have a thousands of rows of data where there are 3 - 5 rows with the same record # (but ending in with different text) that I need to keep together. Each row has a different date that I need to have sorted chronologically.
I've heard someone suggest grouping; the problem is I have so many rows and have to refresh this spreadhseet periodically making it incredibly burdensome to highlight every 3-5 rows, grouping then sorting.
Is there any way to write a macro to automatically group every row that has a # starting with the same 3 #'s.
Or is there another way to keep the #'s together and sort by date?
Thanks for any help.
Bookmarks