MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Auto-Extract Rows based on filter results


Posted by Peter on August 30, 2001 2:59 AM

I am trying to automate the cutting and pasting of a number of rows from a table based on the results of a filter then calculate appropriate column totals.

Extracts will occur over time and accordingly the number of rows at any point is unknown as the table data will be in a state of flux.


Posted by Barry Katcher on August 30, 2001 6:11 AM

Peter, if I understand your situation correctly, I have just completed a macro to do the same thing. I used the Filter-Advance Filter function with a dozen or so different criteria I set up, and used the "Copy to another location" option to paste the filtered rows to a range directly below my database.

For more detailed info, and a copy of my code, contact me at "barrydkatcher@beethoven.com"