New worksheet based on cell value

[SplatP1]

Hello,

Column A contains the country codes (with a header row). I need a solution that can make new worksheets based on the country codes.
i.e. All rows with country code AA on one worksheet, all rows with country code AB on another worksheet etc.

Anyone able to help?

Cheers
Owen

 

[dmt32]

Hi,
try code (#post 2) I posted here:https://www.mrexcel.com/forum/excel...t-another-based-value-column-first-sheet.html

and see if does what you want.

Dave

 

[SplatP1]

Dave, you are the man. ray:

Thanks a lot for the quick solution. Works perfect!

Cheers
Owen

 

[dmt32]

Dave, you are the man. ray:

Thanks a lot for the quick solution. Works perfect!

Cheers
Owen

most welcome - many thanks for feedback

Dave