+ Reply to Thread
Results 1 to 3 of 3

Retaining Cell Data after Sorting

  1. #1
    Registered User
    Join Date
    12-06-2007
    Posts
    5

    Retaining Cell Data after Sorting

    Greetings,
    I am trying to figure out how to keep cell data that is copied from data on a different sheet even after sorting the original data.

    I have an example attached for more clarification.

    I have two sheets, the original data set on sheet1, and the copied data on sheet2. My goal is to have columns B and C on the second sheet equal to those the same respective cells on sheet1. However, when I try sort sheet1 data, data on sheet2 is no longer accurate. Is there a formula to use to copy data from a cell, regardless if the original cell's position changes later?

    Thanks!
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    08-14-2006
    Location
    USA
    MS-Off Ver
    2019
    Posts
    686
    FORGET IT THIS WON'T WORK FOR YOU SINCE YOUR CELL ENTRIES REPEAT.
    place these formulas on Sheet2 and copy down

    in Sheet2 B2
    =INDEX(Sheet1!$A:$D,MATCH($A2,Sheet1!$A:$A,0),2)

    in Sheet2 C2
    =INDEX(Sheet1!$A:$D,MATCH($A2,Sheet1!$A:$A,0),3)

    in Sheet2 D2
    =INDEX(Sheet1!$A:$D,MATCH($A2,Sheet1!$A:$A,0)
    Last edited by carsto; 12-18-2007 at 11:52 PM. Reason: didn't realize your cell entries in column A repeated. This won't work for you.

  3. #3
    Registered User
    Join Date
    12-06-2007
    Posts
    5
    Thank you very much!

    I should clarify, the actual data does not repeat; I should have shown that in my example.

+ 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