Hello,

I have a spreadsheet sample attached below. Basically, I have a sheet
with the follow fields:

TOTALS 210 460 45.7%
Toy Color Accts Atts Pass
Ball Blue 20 100 20.0%
Ball Black 30 90 33.3%
Bike Blue 40 70 57.1%
Frisbee Red 60 55 109.1%
Toy Blue 50 60 83.3%
Star Red 10 85 11.8%

What I would like to do is set up an autofilter using checkboxes. I
would like to create a series of checkboxes that will show above the
sheet each labelled like "Red", "Blue", and "Black" where a user can
select either one color, multiple colors, or all colors, and the list
will only show the colors specified. I also want it to recalculate the
totals based on the checkboxes selected. Does anyone have any ideas as
I am stumped for the moment.

Thanks!

Vassago


+-------------------------------------------------------------------+
|Filename: Sample.zip |
|Download: http://www.excelforum.com/attachment.php?postid=5125 |
+-------------------------------------------------------------------+

--
Vassago
------------------------------------------------------------------------
Vassago's Profile: http://www.excelforum.com/member.php...o&userid=36906
View this thread: http://www.excelforum.com/showthread...hreadid=566204