Dear experts

i have excel master data i want split ethic group by easy way iam seeking help

i have userform1 listbox fill data with A:A & group(Sementism/Non sementism) E:E col

i want split them with multi selection of names and click Command category its move to

with exact data.

for e.g
10 people in non sementism

if i select 5 people from non Sementism and click Maghreb of North Africa those data move to Genetic_Tree sheet
if i select 5 people and click Rest of All Non Sementism Only Non Sementism will move to Genetic tree sheet
if i click All Non Sementism all Non Sementism will move to Genetic tree sheet

like that for sementism

it show off if member move show rest of data only in listbox.

Attached Files

FJA.xlsm (45.3 KB, 4 views)