copy sheet based on table, rename, and hyperlink table to new sheet

Hi ALl,

Had to make a new account but I am glad to be back on the forum \\

I've been working on a macro that makes copies of a template sheet based on a table in my Opps sheet. If column B isn't empty, make a copy of the template sheet, rename it to Opps column A, and then hyperlink column A's current A.row to the newly copied and renamed sheet.

I'm not sure what is wrong exactly, it keeps making duplicate Template(x) and stops renaming them, and the hyperlinks are not working. -This is my first go at VBA hyperlinks to internal workbook sheets so any help there would of course be greatly appreciated as well

Happy Funday Monday!

Please Login or Register  to view this content.

Hey Mike!

Can keeping the sheets "normal" hidden still work with the hyperlinks? I do not want to hide them in a way where VBA is needed to unhide them. The goal is to not clutter the sheets tabs

Attached the template workbook I am using to build the macro off of. Currently still having trouble with hyperlinks.

My goal is to have the Hyperlinks allow you to click on the Company name in Sheets("Opps") in COlumn A, and bring you to their respective Sheet, Sheets("CompanyA_Prcs") etc.

I am also having trouble getting the macro to avoid copying the header row, row 1, it keeps making sheets for Product1_Prcs, Product2_Prcs etc. This should be an easy fix with the ranges I have set but so far it's escaped me.

Thank you for the assistance, I greatly appreciate the support as I get back into VBA

Originally I was planning on doing something like that but when the sheet count gets to be 50+ just from this macro, the hyperlinks would add a level of convenience that I want to continue pursuing

Is hyperlinking like this difficult in general? I have not been able to get my hyperlinks to actually redirect tot he correct sheets thus far.

Figured it out! Had a problem with the variables I was suing to make the hyperlink, all done now :D

Please Login or Register  to view this content.