Copy Worksheet-Hyperlink-Rename based on cell

[jsher1]

Need some help writing a macro that will do the following;

1. Prompt for cell selection
2. Copy a hidden "template" worksheet to the end of the sheets
3. Rename that worksheet based on the cell selection from step 1
4. Hyperlink the cell selection to the newly copied worksheet

Update- I did also post this on the excel forums site. https://www.excelforum.com/excel-pr...1247406-vba-to-copy-rename-and-hyperlink.html

 

[Macropod]

Cross-posted at: https://www.excelforum.com/excel-pr...1247406-vba-to-copy-rename-and-hyperlink.html
Please read Mr Excel's policy on Cross-Posting in rule 13: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html

 

[jsher1]

Cross-posted at: https://www.excelforum.com/excel-pr...1247406-vba-to-copy-rename-and-hyperlink.html
Please read Mr Excel's policy on Cross-Posting in rule 13: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html

Sorry about that, new here. correcting now.