I need to figure out a way to reference a filter result.
For example, say sheet1 has some data, with column labels. I have filter selected, and you can select the item you want to see from each filter.
After the user selects the appropriate filters, he/she is left with one result. Unfortunately, excel still gives the result its original Row #. Say I have 2000 rows worth of data. The column labels take up just the top row, so after filtering, the appropriate result is shown directly below the first row; however, it is still labeled with its original row #.
How can I reference the result of an arbitrary filter in another sheet of the workbook? It would be preferable to not use a macro, since this document will be disseminated to many people, most of which are laymen.
I very much appreciate any help.
Thanks!
Bookmarks