Data=>Filter=>Autofilter should work without any code.

--
Regards,
Tom Ogilvy


"GBH99" <GBH99@discussions.microsoft.com> wrote in message
news:F7992433-7D6D-4A9D-B249-6845D819DA23@microsoft.com...
> 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