I am trying to copy the information selected in the "Order form" and consolidate it into the "Order Summary" sheet.
If someone could help me with a function/formula that searches the "Order Form" and filters all the items that have had a number added in the "Qty" Column and place them and their correlating txt chosen from drop down box into the "Order Summary" sheet it would be greatly appreciated. (Please excuse the messy sheet but had to remove macro's to reduce file size.)
Thanks in advance
Brad