Hi All

background on the setup and what I want to do:

Columns A to C contains details eg Name, Email, Company.
Columns D to H refers to distribution list, eg Test, Dept A, Dept B - this is where I need to select which list the person belongs to - could be multiple.

So, when I select Test & Dept B for a person, his details (Columns A - C) is then copied to two different sheets called Test & Dept B (these sheets later exported to csv etc as required)


I've been through a few examples found on the net that looks similar but seems the rows only have one checkbox to trigger the copy and not sure how to implement the suggested solutions for multiple check boxes.
I would also like to remove the details from the relevant distribution sheet if I uncheck (and removing the blank like if possible - nice to have).
I'm not stressed about alphabetical sorting in the distribution sheet - can still do this manually (which will resolve the blank line issue as well.)

I have two selection options setup - Check Box linked to the cell, or the Marlett option found on another site.
(The Marlett option is easier that linking cells with the check box)

Any suggestions how to do this? I can upload a sample if required?

PS: All I know about VB code is what I copy and paste and then trying to figure out how to alter for my needs, so please excuse any dump questions from my side.

Thanks!!