Excel Autofiltering data to a new worksheet

Hi All: I have a workbook with a Master Worksheet that links to other worksheets in this same workbook. What I'd like to do is to use "AutoFilter" to extract data from this Master Sheet and output the results to a new sheet in this same workbook with all related information (ie. rows and colums) [ie. Get data from column "STATUS" with the word "READY", output all rows/columns to a sheet called "RESULTS"].

If "autofilter" would not be good enough (I tried with no success), could you please let me know what would be the best way and how to do it?

Any help/pointers would be greatly appreciated.

Happy Holidays,

Hong

There are two ways (at least) to do this:

Way one: generate a pivot table from your data, select from the field the data you want to be included, double click on the data number in the pivot table and a new worksheet is created with only your selection

Way two: write a little vba porocedure which loops through your sheet, copies each row which is visible to a new sheet. The property you check for is hidden and is false if the row is visible.

Does this help enough or do you need more detailed solution?

Robert.

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.

Archive of Mr Excel Message Board

Autofiltering data to a new worksheet

Re: Autofiltering data to a new worksheet