Hi,
On Book1.xlsm there is a product table for company BF with all their products, ranges for each product and colour for each range.
For spreadsheet "Quotations" you can choose the company, product, range and colour on a dropdown list, as per row 2. The VBA code I wrote only works for row 2, how do I get it so that for each row 2 - 31 a person can input different choices?
Am not sure how to loop it in this case, because for each row the parameters in row one of the dropdown spreadsheet need to change?
Thanks
Bookmarks