I have a complex spreadsheet which has blanks so therefore i can't us
advanced filter. There are too many columns to create a macro to us
autofilter so I was wondering if there is any vba code which will allo
me to filter all columns other than the current year. The data goes bac
to 1996.

Cheer

--
Message posted from http://www.ExcelForum.com