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
I have also posted this question on the Mr. Excel forums. Appreciate any help I can get.
Bookmarks