View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Al Franz Al Franz is offline
external usenet poster
 
Posts: 21
Default Copy Filter Selection to a Cell ?

Have a Filter setup on a spreadsheet in a Year column, so I can select what
YEAR data to view. Is there anyway to have the selected YEAR to display in
another CELL (on same spreadsheet or another worksheet on a new tab) which I
use for printing a customized summary report of my data.