Sort data from 1 work sheet into another

A

andrewgwatson

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.
 
Top