Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
adjacent cells?
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
adjacent cells?
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 wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Yes or No for adjacent cells | Excel Worksheet Functions | |||
By selecting cells adjacent to cells tally sheet | Excel Worksheet Functions | |||
How do I fill (copy) nonadjacent cells to adjacent cells? | Excel Discussion (Misc queries) | |||
Paste to adjacent cells | Excel Discussion (Misc queries) | |||
selecting non adjacent cells | Excel Worksheet Functions |