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