+ 1 Votes try using vlookup jdclyde 2 years ago to pull out the data you want. this makes it flexible for searching for data. if you could give a better example of what you are doing it would be easier to give an answer. what are you sorting on, what are you looking for, and how would pulling new data to the top or bottom do anything except change what data is pulled out (based on referencing a specific cell on the other tab) + 0 Votes Reponse To Answer jdclyde 2 years ago Glad I could help. how about marking my post with the "+" to show it helped? I guess this is the new system for keeping track of people that are the most helpful instead of the old "Thumbs up" or even before that, the dreaded "tech points" + 0 Votes Success jserra87 2 years ago It took a bit of fumbling and a lot of confusion but it turns out vlookup is just what I needed! Thank you!