I have 9 columns of data in sheet 1 and need to paste data from column H in sheet 1 to a specific column in sheet 2. The data that I need sorted before pasting it into sheet 2 needs to meet a certain criteria, ie; column H in sheet 1 has numbers ranging from 0 to 100000. I need to sort out the numbers between 0 and 50000 and paste these numbers into sheet 2 into column D.
I know there is a formula to do this but I cannot find it anywhere, can you please help.