+ Reply to Thread
Results 1 to 2 of 2

row#s of certain data in a table - Sort Data - How to update table w/new row#s?

  1. #1
    Registered User
    Join Date
    09-25-2007
    Location
    Australia
    Posts
    1

    row#s of certain data in a table - Sort Data - How to update table w/new row#s?

    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

  2. #2
    Forum Contributor
    Join Date
    07-05-2007
    Location
    Lexington, MA
    Posts
    302
    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.
    FrankBoston is the pen name for Andrew Garland, Lexington MA

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1