Checkboxes and autofilter

Hi All,

I have been stuck on a problem since yesterday and I just can not figure out how to get this to work.

I have 3 sheets

Sheet 1 contains the table of data columns Col A to Col E

Sheet 2 contains check boxes which have been created from the values in columns A to E from Sheet 1

Is there any way to link the check boxes to control the auto filters on columns A to E on Sheet 1

Example: Sheet 1. Column A contains 50,000 rows but this is made up from 7 different values. So on sheet 2, 7 check boxes are created and the caption is the value.

I now need a user to select by using the checkboxes which data to show on sheet 1.

Hope this makes sense, Any ideas ?

Thank you

LeeroyB

Hi Roger,

I have attached attached a link to dropbox so as you can download a sample of the workbook.

Sheet 1 contains the data and sheet 2 contains the checkboxes.

Thanks

Leeroy

http://dl.dropbox.com/u/6910979/Book1.xlsx

I think I need to build an array from the checkbox values depending on if they are checked or not and this array can be passed to the autofilter on sheet 1 .

Thoughts anybody ?

In case anybody is trying to work this out do not worry as i have fixed this problem.

Thanks

LeeroyB