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

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" 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

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

Thanks for this, is there anyway of displaying the info in a list of cells.
For Example if the actor is Sean Connery and the Genre is Action for it to
list all his bond movies and the Rock in say cells c10 onwards?

"Norman Jones" wrote:

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" 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

Hi GBH99,

Thanks for this, is there anyway of displaying the info in a list of
cells.
For Example if the actor is Sean Connery and the Genre is Action for
it to list all his bond movies and the Rock in say cells c10 onwards?

Consider the use of the Autofilter or Advanced Filter features.

Debra Dalgleish has tutorials on her Contextures site:

http://www.contextures.com/xlautofilter01.html

and

http://www.contextures.com/xladvfilter01.html


---
Regards,
Norman



"GBH99" wrote in message
...
Thanks for this, is there anyway of displaying the info in a list of
cells.
For Example if the actor is Sean Connery and the Genre is Action for it to
list all his bond movies and the Rock in say cells c10 onwards?

"Norman Jones" wrote:

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" 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