Checkboxes to populate other sheets

[Soarra]

Hi guys,
im trying to use my first page which has class names, numbers and checkboxes for different professions to populate sheets for each profession.
excel.png


so if i checkbox are true for class 3 for mechanic and manager if will fill the manager and mechanic tabs with class name, number and hours.
is this possible?
thanks
artie

[Kevin#]

This illustrates one approach avoiding use of checkboxes.
Use of Marlett font instead of checkboxes.
with this font "a" becomes a tick
Much easier to handle than checkboxes
Can then use data filter and SpecialCells type Visible to select the data

To run macro in attached file {ctrl} + t

Please Login or Register  to view this content.

[Soarra]

Thanks. I like that idea. Hate working with check boxes.

[Kevin#]

Then you may like this extra twist
There is now data validation in the cells in columns C to E which allows user to select Yes or No. When either is selected the cell shows either a "tick" or a "cross" (by inserting the code below into the worksheet module)
(see attached workbook)

Please Login or Register  to view this content.