Without knowing too much what you want I would suggest select all the
tables, then do datafilterautofilter
That will create the dropdowns and you can select items or create custom
filtering like a certain date range etc.

Post back if that isn't what you want

--


Regards,


Peo Sjoblom

"Tiffany" wrote in message
...
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.