Sorting Rows to another worksheet

  • Thread starter Thread starter Sizzle27
  • Start date Start date
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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Need to count no. of rows where cell in column A = "value1" AND cellin column B (same row) = "value2 2
Combining worksheets 3
Copy certain rows to new worksheet 1
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 1
extracting multiple rows of data from another worksheet 1
Lookup 14
Worksheet data sorted on another worksheet 1

Back
Top