I have a command button on the worksheet 'Coupon' that when I click it I want it to insert values from the active row in a table to certain cells (shown in example code attached) in the 'Selections' worksheet then show the userform. I tried to extract some code from another macro where I insert these values from 'Coupon' to 'Selections' but it did not work. Attached is an example and the code that I attempted (but failed!!).
Bookmarks