You need an ID field in the Alias rows that you can find again after sorting.
The Duplicates rows should refer to the ID number as the "soft" link that survives sorting. The Duplicates rows can also hold the "hard" row number as a convenience for looking up the Alias rows quickly.
You will need to do a search (by Subroutine or Worksheet Function) after you sort Alias, to restore the "hard" row number by looking for the "soft" ID.
As a complication, you need to store the last ID number used, so you know how to label new Alias rows.
Bookmarks