I am looking for a solution to the following:
user selects a quantity of various product from sheet 1.
Sheet 2 then lists the quantity and product down columns A & B based on the selection of Sheet A.
Once that order is completed it continues to save the next order on the next available open row.
user selects a quantity of various product from sheet 1.
Sheet 2 then lists the quantity and product down columns A & B based on the selection of Sheet A.
Once that order is completed it continues to save the next order on the next available open row.
