Sorting Rows to another worksheet

S

Sizzle27

Hi,
I have a table and I would like to move/copy only the rows that meet a
certain criteria into another worksheet.
For example

Name Address Age
susan Reading 27
Scott brighton 2
mark stoke 14
brian hampshire 34

So I would like to have another worksheet where all people of age
between 20-30 with all their relating columns are shown. Does this make
sense?
Is this even possible?
any help would be great!
thanks,
Sue

P.s. have tried Iif statements but that only returns the one column I
set the criteria for.
 
R

Roger Govier

Hi

You could use Autofilter to select qualifying data, then copy visible
range to another sheet.
Mark you range of data>Data>Filter>Autofilter
Select dropdown on Age Column and choose Custom> enter
=>19 in the first pane and leave the radio button set to AND
=<31 in the second pane

Select the Visible set of data and Copt to another sheet.
 
Top