View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
edward edward is offline
external usenet poster
 
Posts: 87
Default using autofilter data

Is it possible to get access to data appearing on the auto filter dropdown
lists which show at the top of the filtered range?
Would it be possible to control filtering operation from data validation
dropdown lists put on a different worksheet than that containing the
filtered range?