adjacent cells?

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
 
T

Tyro

You use the term "populate", does than mean one entry on the sheet or
10,000,000? In other words, fill in one cell or many?

Tyro
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top