K
Katmouse
This is probably a lot easier than I'm making it, but I'm lost!
I've created a multi-sheet workbook in Excel 2007 to keep track of our DVDs,
audio CDs, video games, etc. Each sheet is devoted to a specific media type.
I'm about to start entering our audio CDs, and here's what I would like to
accomplish:
First field: Artist Name
Second field: Name of album/CD
Third field: A dropdown list of the tracks on that CD.
Everything I've seen/read about creating combo boxes/dropdown boxes indicate
I have to enter the information that I want to appear in the dropdown
somewhere else in my spreadsheet, which to me seems to defeat the purpose of
what I'm attempting to accomplish. I don't want this dropdown to be
'selectable' as one would normally expect from a dropdown, meaning this
isn't a form someone is going to be choosing an option from via the dropdown,
I just want a dropdown of static information so if, let's say, I'm looking
for a specific
song by a specific artist, I can find it easily. I don't need this
information to be searchable; however, if it ends up that way that's
obviously fine and would be nice, but just not mandatory. Is what I want to
do possible?
Any help/guidance would be greatly appreciated. I used to work for Microsoft
but I never dealt with Excel much and I'm really clueless on the development
side! I did end-user support in operating systems and networks! Thanks in
advance for any help anyone can provide. Just remember, I'm not a programmer
or developer, so any help needs to be "dumbed down" for a network gal who
doesn't know the first thing about programming!! Feel free to email me:
(e-mail address removed) - thanks again!
Kathy
I've created a multi-sheet workbook in Excel 2007 to keep track of our DVDs,
audio CDs, video games, etc. Each sheet is devoted to a specific media type.
I'm about to start entering our audio CDs, and here's what I would like to
accomplish:
First field: Artist Name
Second field: Name of album/CD
Third field: A dropdown list of the tracks on that CD.
Everything I've seen/read about creating combo boxes/dropdown boxes indicate
I have to enter the information that I want to appear in the dropdown
somewhere else in my spreadsheet, which to me seems to defeat the purpose of
what I'm attempting to accomplish. I don't want this dropdown to be
'selectable' as one would normally expect from a dropdown, meaning this
isn't a form someone is going to be choosing an option from via the dropdown,
I just want a dropdown of static information so if, let's say, I'm looking
for a specific
song by a specific artist, I can find it easily. I don't need this
information to be searchable; however, if it ends up that way that's
obviously fine and would be nice, but just not mandatory. Is what I want to
do possible?
Any help/guidance would be greatly appreciated. I used to work for Microsoft
but I never dealt with Excel much and I'm really clueless on the development
side! I did end-user support in operating systems and networks! Thanks in
advance for any help anyone can provide. Just remember, I'm not a programmer
or developer, so any help needs to be "dumbed down" for a network gal who
doesn't know the first thing about programming!! Feel free to email me:
(e-mail address removed) - thanks again!
Kathy