have you evaluated the built in capabilities of the Autofilter under the data
menu?

It does exactly what you describe with no programming.

--
Regards,
Tom Ogilvy


"spartikus411" wrote:


i have a lot of info all organised with dates in the 01.01.2006 format,
and company names and number of boxes shippped (a bunch more too), i
need to create an interactive menu that will allow date, name, number
of boxes filtering options, and this i would like to be in drop down
form. any help would be amazing since i have no expierence in VB
really, but i do in over 10 other ones. i know this is probably a lot
of work so if anyone could help this would be greatly appreciated.
thank you.

Mike


--
spartikus411
------------------------------------------------------------------------
spartikus411's Profile: http://www.excelforum.com/member.php...o&userid=34933
View this thread: http://www.excelforum.com/showthread...hreadid=546666