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!
Bookmarks