hi
all
I want to show value from cell b2 on sheet 1 on sheet 2 cell c2 which I know is
=sheet2!c2
but if I filter any columns on sheet one the row's move up and show the filtered data now my problem is I want to show the value at the top of column c after data has been filter like a subtotal function
on sheet 2 cell c2
thanks in advance
shane
Bookmarks