View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dougout Doug Dougout Doug is offline
external usenet poster
 
Posts: 1
Default Advanced Filter in Excell

In excell, I use (Data,Filter,Advanced) to extract filtered data from a list
and copy it to another location, but up until now only on one sheet, no
problem, but now need to same operation from larger database.

Can anyone show me how to use this "ADVANCED FILTER" using a "List Range"
that extends across multiple Sheets in the same workbook?

Dugout Doug