Copy entire rows matching condition to a new sheet

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.

--
Don Guillett
SalesAid Software
[email protected]
"JP" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>

Hi JP

Check out
http://www.rondebruin.nl/easyfilter.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl



"JP" <[email protected]> wrote in message news:[email protected]...
> 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
>

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.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"JP" <[email protected]> wrote in message
news:[email protected]...
> 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
>