I have a form that allows the users to select a GT Size and the quantity
If user select 750, qty of 1, then everything in the yellow rectangle will be added to a csv file that is already open, after the last active row.
if user select qty of 2, then everyting in yellow rectangle will be added to the csv file twice (12 new rows of data)
if user select 1000 Gallon, qty of 2, then everyting in red rectangle will be added to the csv file twice (12 new rows of data)....etc
how to use VBA to achieve this ?
PS: right now all the values in the screenshot are in a database in a xlsb file, which is also where the userform is located.
so the VBA code will just be copying these values from the xlsb to the csv.
If user select 750, qty of 1, then everything in the yellow rectangle will be added to a csv file that is already open, after the last active row.
if user select qty of 2, then everyting in yellow rectangle will be added to the csv file twice (12 new rows of data)
if user select 1000 Gallon, qty of 2, then everyting in red rectangle will be added to the csv file twice (12 new rows of data)....etc
how to use VBA to achieve this ?
PS: right now all the values in the screenshot are in a database in a xlsb file, which is also where the userform is located.
so the VBA code will just be copying these values from the xlsb to the csv.