Copy entire rows matching condition to a new sheet

  • Thread starter Thread starter JP
  • Start date Start date
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
 
This could be done by using the data>filter>autofilter. Record a macro while
doing it so you can modify to do it again.
 
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.
 
Back
Top