Data=Filter=Autofilter should work without any code.

--
Regards,
Tom Ogilvy


"GBH99" wrote in message
...
I am trying to catalogue my DVD collection by main character and by genre.
I
want to be able to display my lists of films when selecting one of each of
these 2 variables, is this possible to do in excel?

I am currently using drop down lists to select each of the variables but
cannot work out how to programme the cells to except the data. Please can
you
help? Even I need to create a Macro please can you start me off on the
right
track.

Many Thanks