How do i pull details from a table to appear as a list in excel?

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

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

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

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" <GBH99@discussions.microsoft.com> wrote in message
news:A5328FA0-3172-4837-B1E4-26E8EC773E90@microsoft.com...
> 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" <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
>>
>>
>>