Split single excel worksheet into multiple worksheets

Closed
Report
Posts
1
Registration date
Thursday April 13, 2017
Status
Member
Last seen
April 13, 2017
-
While I see many VB solutions 'almost' there, I don't see a solution for me.
Challenge is I have client data where each set of data has 'Patient Code:' in column A of Row N, and the Code, say 'GOLMOR' or 'JOBVIN' adjacent in column B of row N.
I'd like every row beginning with Patient Code..., down to the next Patient Code... in a new worksheet named GOLMOR or JOBVIN etc. There are actually about 60+ rows per client, and 50+ clients, but reduced here for this description. Any code should stop at the first blank row.
e.g.

Any help would be appreciated.