I am fairly new to Excel but can do some formulas. I have difficulty with a spreadsheet I have created. I am trying to create a seperate worksheet in the attachment which outlines a couple of things. Basically trying to create a summary sheet of the order form. Wanting to know the name, size and quantity ordered for product code A9089 - Navy L/S, and the same for the additional items in the order form. I would like to have the sheet setup so that it will pull all the orders with sizes and quantity into one sheet - basically giving me an overview of the total shirt quantity and size for each item. Is there a way to create this?
Bookmarks