generating filter outcomes on a new worksheet

September 23, 2010 at 02:22:17
Specs: Windows XP
How to automaticly generat filter outcomes on a new work sheet in excel 2003

See More: generating filter outcomes on a new worksheet

Report •


#1
September 23, 2010 at 04:13:55
Feel free to throw in a "Please" and a "Thank You" when posting in a help forum such as this. We are all just volunteers here giving of our free time.

You cannot "push" the filtered data to a different sheet via the Filter dialog box, but you can "pull" it.

1 - Name the range that you want to filter, e.g. myRange.

2 - On the sheet where you want the filter data to reside, open the Filter dialog box and use =myRange in the "List range" field.


Report •
Related Solutions


Ask Question