# Sorting a list of items into 2 separate lists

#### Gringo123

##### New Member
I work for a printing company that prints labels. We have 6 printing presses, lets call them A,B,C,D,E & F.
Certain labels can only be printed on printing press F.

From our business system I can run a report in excel format giving details of all the labels that we have sold in the present month. I need split that report into 2 separate excel spreadsheets; 1 showing everything that was printed on presses A to E and the other showing everything printed on press F.

I also have another excel spreadsheet which gives a complete list of all the labels that have to be printed on press F.

At the moment I do this task manually. Can excel perform this task for me?
Every label that we print has a part code and both spreadsheets show this part code so that would be the linking factor between the 2 sheets.

### Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use \$ signs: \$V\$2:\$Z\$99 will always point to V2:Z99, even after copying
I work for a printing company that prints labels. We have 6 printing presses, lets call them A,B,C,D,E & F.
Certain labels can only be printed on printing press F.

From our business system I can run a report in excel format giving details of all the labels that we have sold in the present month. I need split that report into 2 separate excel spreadsheets; 1 showing everything that was printed on presses A to E and the other showing everything printed on press F.

I also have another excel spreadsheet which gives a complete list of all the labels that have to be printed on press F.

At the moment I do this task manually. Can excel perform this task for me?
Every label that we print has a part code and both spreadsheets show this part code so that would be the linking factor between the 2 sheets.

I think you should take a look at VLOOKUP and maybe somehow you can apply that too your situation. If you posted a sample of the layout for both sheets, then you would probably receive more replies with better solutions.

Replies
7
Views
329
Replies
9
Views
805
Replies
0
Views
290
Replies
2
Views
224
Replies
1
Views
207

1,196,053
Messages
6,013,119
Members
441,749
Latest member
batel19

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back