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

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

thanks a lot.
one problem though, when i try to custom filter the dates, like usin
ends with or contains 02.2006 or something like that so i can do mont
specific it comes back with no matches. how can i correct this

--
spartikus41
-----------------------------------------------------------------------
spartikus411's Profile: http://www.excelforum.com/member.php...fo&userid=3493
View this thread: http://www.excelforum.com/showthread.php?threadid=54666

trying to keep it up at the to

--
spartikus41
-----------------------------------------------------------------------
spartikus411's Profile: http://www.excelforum.com/member.php...fo&userid=3493
View this thread: http://www.excelforum.com/showthread.php?threadid=54666

I would use a dummy column with a formula that identifies the month and then
use that column for filtering on month.

alternatively, if you use the custom function, you can bracket the month

= first of the month
and
<= End of the month

--
Regards,
Tom Ogilvy


"spartikus411" wrote:


trying to keep it up at the top


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

ok now how can i get the results remaining to add up all the numbers in
a specific column?


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

trying to keep it up top


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