excel help needed

symy@nufc

hi guy!
am havin trouble useing drop downs in excel!!
am not the best at it . i will try and explain av made a album list wat am trying to do is put all the songs into a drop down so i can see whats song are on the album. av used mediamonkey to create a song list to excel copyed it but it will not let me paste it to coments box???
is this me just being thick???

bengalknights

meadinkent.co.uk/xldropdown.htm

dont know if thats any use to you

rmg1

If you list the albums and the songs in columns A/B respectively you can use autofiltering.
You would end up with something like:-
Column A....Column B
Album 1......Song 1
Album 1......Song 2
Album 1......Song 3
Album 1......Song 4
Album 1......Song 5
Album 2......Song 1
Album 2......Song 2
Album 2......Song 3
Album 2......Song 4
Album 2......Song 5

Using autofilter in Column A, you can select the album to see what songs are on it, autofilter in Column B will allow you to select a song and show the song and the album it's on.