I have a form on sheet 1 where only selective date is entered onto sheet 2.
However, on Sheet 2 I have Row 1 columns filled from A:BCL with numbers.
On Sheet 2 what I need is
The account number from sheet 1 (simple)
and the quantity selected of a product selected from sheet 1.
Unfortunately, due to compatibility issues I need every product ID listed on Sheet 2 already populated.
What I am trying to do is
User enters customer ID (Sheet 1)
Selects Quantity of various products (Sheet 1)
and those are moved to sheet 2. Once they click on next order it clears out sheet 1 and what ever is selected is moved to the next row in Sheet 2 and so on...
Any Ideas?
However, on Sheet 2 I have Row 1 columns filled from A:BCL with numbers.
On Sheet 2 what I need is
The account number from sheet 1 (simple)
and the quantity selected of a product selected from sheet 1.
Unfortunately, due to compatibility issues I need every product ID listed on Sheet 2 already populated.
What I am trying to do is
User enters customer ID (Sheet 1)
Selects Quantity of various products (Sheet 1)
and those are moved to sheet 2. Once they click on next order it clears out sheet 1 and what ever is selected is moved to the next row in Sheet 2 and so on...
Any Ideas?
