Archive of Mr Excel Message Board
Back to Data in Excel archive index
Back to archive home
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.
Re: Auto-Extract Rows based on filter results
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"
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.