Very very large worksheet. Need a kind of filtering macro

[tafoyavision]

I am using 07 excel and here is what I am trying to achieve. I have a very very large worksheet (132,000 rows) and I need to have the worksheet check column CA of each row, and if column CA is >250, I want that entire row copied to another worksheet named buff.

I then need the buff worksheet to check column BZ of every row. If that column of that row is >250, I need that entire row copied to another worksheet named draft.

I then finally need that new worksheet to check column cb. If that row in that column is >150, I need that entire row copied to another worksheet named runout.

So to summise, I need the same functions done on each worksheet, just on a different column with a different value. The final worksheet will have only rows that have buff >250, AND draft >250, AND runout >150...in other words all 3 conditions are met on the final worksheet. Thank you soooo much for all you guys do here.

[Kaper]

Do you really need these intermediate steps ?
If no, you can use Autofilter and set criteria in columns CA BZ etc.
If yes - anyway you can do the sanme with step by step autofiltering.

You can register the macro, while you do these steps, you will have one almost ready to use for next sets of data.

[HaHoBe]

Hi, tafoyavision,

use the Advanced Filter starting from the target sheet with a criteria range to match your requests.

Ciao,
Holger

[tafoyavision]

Kaper and Holger,

Thank you for answering. I do not NEED the intermediate steps but I do need a worksheet only showing the rows with all 3 conditions met. Would I still use autofilter? If so, how would I do that? Thanks again for helping us noobies.

[Kaper]

See attachment - some 175 rows of generated numbers in several columns,
autofilter and first set columns C to show >=250 (only visible only 82) - I used numbers filter above values list for filtering,
then G the same limit - only 39 remains
and finally L>=150 - just 21 remained.

If you now select all (Ctrl+A) copy and paste into another sheet you will have unly this data (whole rows) no empty rows or not-selected data in between.