Hi

Please find attached a sample (contains the code for the Marlett option mentioned).
I've created the 'client details' sheet which contains the client details and various email distribution he belongs too.
Then created a sheet for each list and populated with the info as per the selection in 'Client Details' sheet. The list sheets I want to update automatically as I tick/untick in 'Client Details'

testing.xlsm

Thanks
Jacques