Thanks for that. I have done exactly what you have said, and it works.
Is there a way to use colors or conditional formatting 'Ship Mode' column based on the data in the cell? E.g. First Class = green, second class = amber, and standard class = blue ?
Thanks for your help.