Old Looping Code
Copy and Paste to Next Sheet
Copy and Paste Row to Next Sheet
Copy and Paste Column to Next Sheet
Copy and Paste Range to Next Sheet
Loop Template Code- Start your loop with this.
Adding an Item to the right click menu
If you want to add an item to the right click menu, This is a way to do it.
The below code belongs in a Regular Module. Hit Alt & F11 then select insert module and paste the code there.
The below codes belong in the Workbook Module
Right Click on the worksheet, select "Show Message" and the message box appears.