Attached please find the excel sheet MyCurrentRecordset that shows the records that I currently have sorted by OrderNo.
But I would like to get this sorted like shown in the worksheet MySortedRecordset that shows the records sorted by OrderNo &OldOrderNo(if there is any available for that OrderNo).
Is this possible to get this sorting done in excel ???
The reason is I have about more than 2000 rows that need to be sorted in this manner.
The entire excel is originally sorted by the OrderNo column.
the challenging part is ... if there are any OrderNo that has a OldOrderNo in column2...it has to be moved and put it together underneath their respective OrderNo in column1.
Any ideas how I can accomplish this kind of sorting in excel ???
Thanks very much in advance!