Create new tab and copy rows of data

[PayrollScotland]

Hi, can anyone help me write code to create a new tab, to be named the value in column B and copy all the rows of data that contain this value.

Example, below with dummy data, please note we can have 50,000 rows of data.

Thank you!

 

[mumps]

It is hard to work with a picture. It would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach a screenshot (not a picture) of your sheet. Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here.