Hi Lasant, welcome to the forum.
1. Add a command button to your "All" worksheet from the Controls Toolbox toolbar (not the Forms toolbar).
2. Double-click the button to open the VB Editor
3. Copy the code shown below and insert it between the new section of code that will appear ("Private Sub CommandButton1_Click() ..... End Sub").
You can then close the VB Editor window. Also, you can right-click on the command button and choose Properties to set it's Caption (e.g. "Update Renewal Sheet") and it's font color, background color, etc. Once you're done formatting the button, click the Design Mode button to take your worksheet out of Design Mode (looks like a small triangle with a ruler and pencil).
All that's left to do then is click the button and let the macro do its job. Try this on a backup workbook first, of course!
Bookmarks