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