Hello,
I have created a worksheet which I am using as a template, "Main", and it is hidden in the workbook. I also created a starting page, "Info", to enter account information which contains a command button that when pushed copies "Main", and renames it appropriately, "Page 1", and sets the focus to "Page 1". The issue lies when I am on "Page 1", I am not sure how to make the command button on "Page 1" then copy "Main" and rename it to "Page 2". Since "Page 1" is copied from "Main", the command button matches that of "Main". I would like this to work on multiple pages. Thank you in advance for your help.
Bookmarks