I am trying to create an order form, by which I want the customer to tick-off items they want from a long inventory. I want the checked items to be copied onto another new worksheet, which would be an order, or packing list.
It would likely involve making check boxes to go next to each inventory item. Then, a submit button that would trigger a macro to create a new worksheet and copy the selected items to a clean order form.
Has anybody done something like this? Seems simple, but I have been struggling all day! Thanks.
It would likely involve making check boxes to go next to each inventory item. Then, a submit button that would trigger a macro to create a new worksheet and copy the selected items to a clean order form.
Has anybody done something like this? Seems simple, but I have been struggling all day! Thanks.
