Split data into different sheets

I have a large list of items (sample attached)
the part numbers can end in different ways and I want to split these onto different sheets.

The way it needs to be split is:

no end leave on sheet 1
any ending in -04, -05, -06 on sheet 2
any ending in -14, -15, -16, -18 on sheet 3

Perhaps a macro like this could be of help?

Please Login or Register  to view this content.

Alf

Rereading your question I seem to have missed

no end leave on sheet 1

Change line

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Alf

Hi does look good, but on the real data there is 2 more columns with prices and it is removing them.

So what do I need to change to include 2 more columns?

Thanks

Hi does look good, but on the real data there is 2 more columns with prices and it is removing them. So what do I need to change to include 2 more columns?

If the two extra colums are I and J change line

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Alf