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


Please Login or Register  to view this content.
Please Login or Register  to view this content.