I have set a drop-down list up and would like a single selection to populate
several cells in a row from a table I have set up. Specifically the drop-down
list would offer short form product names. Once selected the choice would
fill in the long description and list price from the second worksheet table I
set up. This is a quote automating tool I am developing.
Thanks in advance.