I'm using a button/macro to generate a new sheet based on a template and then create a reference card ("card") on the master sheet ("Board") that previews a couple cell references ("title" and "owner") on the new sheet and has a hyperlink to take you to the new sheet. My challenge is that I'm trying to use a variable name to ensure that the reference card links to the new sheet instead of the template and it isn't working. The first half of the code works great and copies the "template" sheet well and names it ("Id1, Id2, Id3, etc.") using a variable name (strNewName), but I can't seem to use that variable name with the referencing. My grouping also doesn't seem to be working. Any help you can offer would much appreciated.
HTML Code:
Bookmarks