create a dynamic table based on selected check boxes

your teams dont match your checkbox's on sheet 1

Team
CRVR
CBT
import
WCSA Import
Export

so it wont actually work?

see attached

many things have changed mainly i have grouped your check boxes into 3 groups

Group Team
Group Week
Group Role

this theme's thru all the codes

For instance
in sheet1

Please Login or Register  to view this content.

this code is to select all in team.....similar code for deselecting team and GROUP week

none for role as only 2

the majority of the code is on the update button
code is long as it is doing everything 3 times (due to 3 groups of checkbox's)

Please Login or Register  to view this content.

as there are so many options array's for each criteria was made
check was put in in case too many filters placed and nothing returns

BTW i took away all your Formatting of cells in white and just removed grid lines instead.....it messes with the copying of the formatting
you shouldnt really do it anyway as it makes the file unnecessarily large with formatting of cells you don't really need to

glad you liked

it was a challenge trying to find the syntax for the grouped check boxes
so ill be keeping this one in my database as well