I currently have an order form (workbook A sheet 1) with a userform with listbox that allows me to take all of the necessary information filled out in the form and transfer it to a shipping form (workbook B sheet 1).
What I would like to do is to change it such that a user can single-select the part they need, type in the quantity of which they are shipping it and click the button "add" where the userform clears and the user can add another part from the order to the shipping form. Then, there is another button located on the userform "done" that closes out the userform and saves and closes the shipping form with a unique title.
I have most of the code figured out, besides transferring which parts get to transfer to the shipping form and their new quantities.
I have uploaded the 2 workbooks in here, and the userform code can be seen below.
Please Login or Register to view this content.
I appreciate any and all help!
Bookmarks