The first one is the Worksheet code, it activates when I press enter. This works fine as I only want to copy up to BQ for the next row.
The second one is when I create a new worksheet. I would like it to not copy the "entire worksheet" but only the same as my copy in the first macro, A to BQ. and none of the "buttons" that are on the original sheet.
Now when I run this (second) macro from the "Slide Sheet" tab, it creates the next worksheet "Sidetrack (1)" which is perfect. But since I don't want to transfer the form control buttons to the additional sheets, I would like for it to check if there is a "Sidetrack (1)" sheet and if there is then create the next sheet "Sidetrack (2)" etc.
Thanks for your help
Bookmarks