Macro to make new sheets with names taken from certain column.

[abjac]

Hi I need to have help with a macro. The sheet have headers in row 1. In column AJ. There is country names. I need the macro to created new sheets after the country name, and after transfer all rows with the same country name to that sheet. . So if in column it say Austria. Create a new sheet called Austria. And transfer the rows with Austria in column AJ to that sheet. So after run the macro. All items have been transferred to new created Sheets.- I need the choice of Column to do this after to be possible to change.
Please have a look at below test sheet. More easy to see there-.

Thanks in advance

Sincerely
ABjac

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[JOHN H. DAVIS]

OR:

Please Login or Register  to view this content.

[abjac]

HI John Just tested your codes. They work so good really brilliant. Thanks allot this actually help me allot.
Thanks really,

Have a nice evening.

Sincerely

Abjac

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback.