Hi,

I have a spreadsheet that i have entered all my data and what i would like
to do is creat dropdown menus at the top of each list so that i can easily
sort through all of my information. i.e. if i just want to see information
on a certain state with in my worksheet i would like to be able to go to the
dropdown menue and choose IL and only see the information that i have for the
things within IL.

how do i do this? i thought i might need to use a combobox but i'm not sure.
and if i am how do i make it work for me.