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.

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



"Al Franz" wrote in message ...
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.