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)

could help anyone?

I don't know exactly what you want but it looks like you are looking to use VBA to perform tasks that can be done smarter with a power query, pivot table and slicers.

Are you familiar with those? If not, have a look at some instructional videos on youtube like this one to do the data merge
https://www.youtube.com/watch?v=M_jIsnksv7I

Once you have the data merged, the pivot table and slicers will be easy to implement

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

Can u help in VBA, becoz we hide sheet only userform shows data cant copy and paste data, thats why i need vba code