Split data from main workbook to new workbooks

[YasserKhalil]

Hello everyone
I have two workbooks : main workbook contains the data I wish to split in specific way
The other workbook is a sample of the expected results

I need to split data as illustrated in the sample : to three sheets (Basic - Other - Notes)
"Basic" sheet to include five fields : Name & Date & Nationality & Unit & Class
"Other" sheet to include three fields : Annual & Salary & Additions
"Notes" sheet to include the field : Notes only

The name of the created workbook should be as the Name of the client
Thanks advanced

[YasserKhalil]

Is everything clear ? Or I have to clarify my request again

[YasserKhalil]

I don't know is it difficult or unclear?
Please help me

[YasserKhalil]

How can I achieve that task? Can you guide me?

[GC Excel]

Hello,

Please try this code :

Please Login or Register  to view this content.

[YasserKhalil]

Mr. GC Excel
Thank you very much for that masterpiece. It's working like charm
Thanks alot

[GC Excel]

You're welcome. Thanks for the feedback and the rep !

[sterio]

gc, yasser i am beginner in excel vba could anyone please tell me how to use this code... thank you