Hi GBH99,

See xlDynamics Dependent Dropdowns page at:

http://www.xldynamic.com/source/xld.Dropdowns.html

If you are not familiar with macros, you may wish to visit David McRitchie's
'Getting Started With Macros And User Defined Functions' at:

http://www.mvps.org/dmcritchie/excel/getstarted.htm

You might also look at David's tutorials page at:

http://www.mvps.org/dmcritchie/excel....htm#tutorials


---
Regards,
Norman


"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