Remote Filtering
 

How to i move a list filter from the top of the list to another sheet.

i.e. i want a "front sheet" with various filters which will filter the
data on another sheet and display a total from the list after it has
been filtered.

thanks

Remote Filtering
 

You can start an Advanced Filter from the destination sheet, and refer
to the source list on the first sheet. There are sample files he

http://www.contextures.com/excelfiles.html

Under Filters, look for Product List by Category

wrote:
How to i move a list filter from the top of the list to another sheet.

i.e. i want a "front sheet" with various filters which will filter the
data on another sheet and display a total from the list after it has
been filtered.

thanks



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html