transfer data from sheet1 to multiple sheets based on names in specific column

[abdelfattah]

hi
i hope to help any body about transfer data from sheet1 to multiple sheets the sheet1 contains data from a2:j i would transfer data every code existed in column j where every code to transfer to a new sheet and rename the sheet in column j for instance if the transfer data capital as what exist in column j the sheet's name is capital and so on the rest in code column j and transfer data from a2:j to relating sheet's name is capital and do for all rests i want this by code

 

[Fluff]

You're welcome & thanks for the feedback