I have a worksheet called "Control Plan" with 3 pages of information. The code below (I didn't create but have manipulated it over the years) copies the contents of the second page and relocates it to the next empty row from the bottom. Then it pastes the copied data to create a new page. The contents are cleared from a specific range for new data entry. The process is repeated as new sheets are added.
What I need to happen is for page 3 to always be moved and be the last page of the worksheet before the code runs, regardless of how ever many times the user adds pages. The document grows dynamically when the user clicks on the "Add a Checklist" button on page 2, which now becomes page 3 and so on. The contents on the current page 3 must be moved and always be the new last page every time.
I'm sure this can be done, but I don't know where in the current code to insert new code that will make it happen, without messing up the program.
Bookmarks