Hi,
I have built a quoting tool in Sheet1 and for each quote, the macro saves all the input / output variables of the quote in a new row. Sheet2, (A:BC), keeping all quotes in numerical oreder.
When I quote on Sheet1, if the input variable match a historical quote, then I would like to be notified by excel on what the previous price and quote no. was.
IE. If Client (Sheet1!C3) = (Sheet2!D:D) and Quantity (Sheet1!C8) = (Sheet2!I:I) then I would like the historical quote number returned from (Sheet2!A:A) as well as the price previously quoted (Sheet2!J:J). If there are two matches, then I would like the row with the higher quote number returned.
Many thanks
I have built a quoting tool in Sheet1 and for each quote, the macro saves all the input / output variables of the quote in a new row. Sheet2, (A:BC), keeping all quotes in numerical oreder.
When I quote on Sheet1, if the input variable match a historical quote, then I would like to be notified by excel on what the previous price and quote no. was.
IE. If Client (Sheet1!C3) = (Sheet2!D:D) and Quantity (Sheet1!C8) = (Sheet2!I:I) then I would like the historical quote number returned from (Sheet2!A:A) as well as the price previously quoted (Sheet2!J:J). If there are two matches, then I would like the row with the higher quote number returned.
Many thanks
