Can excel sort part codes for me?

[Gringo123]

In my job I have to take a excel spreadsheet showing all the products that we have sold that month, and separate them out onto 2 new worksheets in order to show which of the items were manufactured in which of our 2 plants. I make this distinction by looking at the part number of each item. Is it possible to automate this task using excel? Can I feed all the item numbers into the program and say ask excel to separate them out for me?

 

[ret44]

You can definitely do that.

First question... What about the part codes differentiates them for the two plants?

 

[Gringo123]

Hi. Thanks for your help.
There is nothing in the part codes that tells you from which plant the item came. 90% are made in plant A and 10% in plant B so the list of plant B items is quite short. Would it be possible to write a progam that recognises this list of plant B items and sepataes them out?

 

[SydneyGeek]

Yes, but we need to see what you are working with.

What do the codes look like?

Denis

 

[Gringo123]

the are 5 number a "-" and 2 further numbers. example: 21458-01
However, there is ni link between the item codes and the plant in which they were made.

 

[SydneyGeek]

You can use Text to Columns to split the codes on the hyphen.
Copy them to the next blank column, go to Data > Text to Columns, select - as the separator, and you will have the codes split into 2 sections.
You can then analyse them according to plant, probably the best option would be to use a VLOOKUP on a table containing the plant names and item codes.

Denis