Hello,

I have a script that runs through a bunch of tags (on the !TAGS sheet), decodes the tag and then associates it with an alias. It then pastes some information to the !ALIASES sheet. Due to the nature of the data multiple tags associate with the same alias. I've got another sheet, !DUPLICATES, that houses the information about any duplicates. One of the columns on this sheet contains the row# on the !ALIASES sheet of the alias it associates with.

The script works beautifully up to here. However, I want to sort the !ALIASES sheet alphabetically once we're finished checking all the tags. Problem is the column in the !DUPLICATES sheet with the row# no longer points to the correct row.

So, my question is, is there any way to update the row#s in said column with the new row#s - post sorting?


Cheers,
Simon