Hi,
Is it possible to create autofilter on Rows?
I have an excel sheet with over 5000 rows and 40 columns and I need to
use the autofilter option on the rows. As transpose function will not
work, cannot interchange rows to columns to use the standard autofilter
option.
Do you know of any macro which can help me in this regard?
Thanks,
Ashwini
Gord Dibben - 30 Nov 2006 18:08 GMT
Check out this google search result.
http://groups.google.com/group/microsoft.public.excel.misc/browse_frm/thread/e6c
b0babfba916b8/6d48bf5680a98d7b?lnk=st&q=&rnum=2#6d48bf5680a98d7b
Note Debra's URL to a workbook.
Gord Dibben MS Excel MVP
>Hi,
>
[quoted text clipped - 10 lines]
>
>Ashwini