Im not sure how to explain this but here goes. I have a workbook that I use for quoting. There is a pricing sheet that has specific Vendors that will be listed when needed. There may be multiple vendors on the same pricing sheet. On another tab in the same workbook I have created a Purchase Order sheet and what I would like is to be able to do is populate the purchase order sheet by vendor. So when I select the vendor on the sheet, it goes out to the pricing sheet and returns all data related to that vendor and ignores all other data. Hope that makes sense.
Thanks for any and all assistance.