Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'm working with two worksheets. Worksheet1, in column A I have years that i
use a filter on. What I want to be able to do is after I filter on the years in worksheet1 is show what year is being filtered in worksheet2. before Filter After Filtering on 2006 2006 2006 2006 2006 2007 2007 2007 I want to show 2006 in worksheet2 cell a1 Please help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to use INDEX? | Excel Discussion (Misc queries) | |||
Chart axes color index vs font color index | Charts and Charting in Excel | |||
How do I pull the col. index value as well as row index value | Excel Discussion (Misc queries) | |||
index/index | Excel Worksheet Functions | |||
how do i get the help index | New Users to Excel |