Copy Filter Selection to a Cell ?  
Author Message
Sebbie





PostPosted: Mon May 16 14:23:19 CDT 2005 Top

Excel Programming >> 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.

Excel269  
 
 
Ron





PostPosted: Mon May 16 14:23:19 CDT 2005 Top

Excel Programming >> Copy Filter Selection to a Cell ? Hi Al

See this page for a code example
http://www.contextures.com/xlautofilter03.html#Copy

My Add-in Easyfilter can also do what you want (and more)
http://www.rondebruin.nl/easyfilter.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl




> 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.
>
>
>
>