Macros to Create New Sheet, Rename, and Create HyperLink to New Worksheet

Hi,

I would like to request assistance for the following:

I want to create a new worksheet based off a template worksheet in my workbook using a macros and button.
Ideally, I would have a cell selected with the name of the new worksheet - Example: Labor 1 in Cell C5.
The button would create a new Labor worksheet and generate the hyperlink to link to the new worksheet on the Index Page and also create a new worksheet based off that name.

In summary:

1. I need to copy "Labor" worksheet and place after the Master Labor Template.
2. Rename the copied ws based on a cell value (C5) from the Index Worksheet (Where the macro will be placed.) or from selected cell.
3. Create hyperlink from the cell value or selection that will link to the newly created worksheet. from the "Index" worksheet.

I keep getting an error message, and the code I am using right now is:

Please Login or Register  to view this content.

Test.xlsm

Thank you!

I keep getting an error message

These kinds of statements are never helpful. If you get an error then tell us where the error is, what line of code, the error number and message.

The only thing I saw in your code was this.

Please Login or Register  to view this content.

I changed it to this and your code seemed to do what you wanted it to do.

Please Login or Register  to view this content.

Also in the future and even now please put code tags around your code so it looks like what I posted above.
Go into your original post, edit, select all your code, click on the # icon in the menu and save your changes.

Thanks.

Originally Posted by jacksum

Thanks, skywriter! It works!

Thanks for the feedback, using the code tags and for the rep. points.

I have one other favor to ask.

Please click the Thread Tools drop down box above your first post and choose solved.