Index
Since you're using years (numbers as opposed to text) you can use this trick.
In Sheet2, A1
=SUBTOTAL(4,'Sheet1'!A:A)
Not a fool-proof solution, but for the manner you describe, it should work.
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"Need_Help" wrote:
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.
|