Copy entire rows matching condition to a new sheet

J

JP

Hi

I want to copy entire rows matching a condition to a new sheet.

The original sheet contains for example a column called impact with values
between 1 and 20. Is there a possibility to automatically copy all rows with
an impact > 16 to a new sheet called Priority 1, all with a value between 12
and 16 to a sheet priority 2, etc instead of copying the sheet manually,
sort the data manually and delete those rows not meeting the criterium?

Thanks very much
 
D

Don Guillett

This could be done by using the data>filter>autofilter. Record a macro while
doing it so you can modify to do it again.
 
E

Earl Kiosterud

JP,

Data - Filter - Advanced Filter does just this. Set up your criteria range
for Impact > 16 etc., and it'll do it. Check it out. To automate it, you'd
need a macro.
 
Top