I am a small distributor that works small manufacturers of gift products. I am trying to make Order Forms (worksheets) and a Master Order Form (worksheet) all in the same workbook. I would like any item on the order forms (VendorA, VendorB, etc) that have an "Order Quantity" of one or more show up on the Master Order Form (All Vendors) along with all the pertinent information in the adjacent cells. This is my first time posting on this forum. Usually I research for my answers without posting, but this time I was not sure how to explain what I wanted. Hopefully this explanation along with the attached file will make my request clear.
Bookmarks