| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.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 "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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I set a cell value to a filter selection in Excel? | Excel Worksheet Functions | |||
| Default Filter Selection to None | Excel Discussion (Misc queries) | |||
| Copy only visible cells after filter is applied/ sum after filter | Excel Worksheet Functions | |||
| Copy one cell to another using a filter | Excel Discussion (Misc queries) | |||
| Copy Selection - Transpose Selection - Delete Selection | Excel Discussion (Misc queries) | |||
Threaded Mode
