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.
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.