Hello there,
Insert an Active X command button onto your worksheet.
Right click on the command button and select the View Code option.
In between the Sub CommandButton1_click() and End Sub copy and paste the below code:
Anything that appears in green is a comment that is meant to help you understand. Please read through the code as it tells you where you need to change ranges to help to code fit your workbook.
Exit out of Visual Basic and then click the CommandButton.
Let me know if this helps!
Thanks!
Bookmarks