D
djohns158
I am using a workbook with 4 worksheets: RFQ, WORKSHEET, QUOTE,
ORDER.... The RFQ worksheet is the request for quote from the
customer. When the customer gives me part #'s to quote for him, I
enter them into the RFQ worksheet. This automatically populates the
"Worksheet" worksheet, where I have cells marked "vendor 1" and "$",
"vendor 2" and "$"... up to 5 vendors. Of the 5 prices I get from
vendors, the lowest automatically populates the Quote worksheet.
Now... the customer might request a quote for 15 part #'s, and out of
those, he might only order 5 or 6 of those parts. Therefore, on the
Quote worksheet, I have a column called "Order" which simply has a
choice box for either Y or N. I have written a macro called "Create
Order" which automatically filters for the items with a Y in the
"Order" column, and then copies and pastes the Quantity, Manufacturer,
Part #, and $ to the "Order" worksheet. However, I now need to
automatically populate on the "Order" worksheet, the name of the
vendor with the lowest cost, as well as the lowest cost itself. Is
there a way I can have the macro search the "Worksheet" worksheet and
find the lowest price for that particular part # and then copy not
only the lowest price in that row, but also the vendor name which is
in the cell to the immediate left of the lowest price? Is this a
vlookup function? I'm pretty lost on this one. Please Help!!!!!????
Thank you so very much.
D Johnson
ORDER.... The RFQ worksheet is the request for quote from the
customer. When the customer gives me part #'s to quote for him, I
enter them into the RFQ worksheet. This automatically populates the
"Worksheet" worksheet, where I have cells marked "vendor 1" and "$",
"vendor 2" and "$"... up to 5 vendors. Of the 5 prices I get from
vendors, the lowest automatically populates the Quote worksheet.
Now... the customer might request a quote for 15 part #'s, and out of
those, he might only order 5 or 6 of those parts. Therefore, on the
Quote worksheet, I have a column called "Order" which simply has a
choice box for either Y or N. I have written a macro called "Create
Order" which automatically filters for the items with a Y in the
"Order" column, and then copies and pastes the Quantity, Manufacturer,
Part #, and $ to the "Order" worksheet. However, I now need to
automatically populate on the "Order" worksheet, the name of the
vendor with the lowest cost, as well as the lowest cost itself. Is
there a way I can have the macro search the "Worksheet" worksheet and
find the lowest price for that particular part # and then copy not
only the lowest price in that row, but also the vendor name which is
in the cell to the immediate left of the lowest price? Is this a
vlookup function? I'm pretty lost on this one. Please Help!!!!!????
Thank you so very much.
D Johnson