Duplicate multiple blank sheets

[VBANovice46]

Hi all,

I have a worksheet that contains 3 different input sheets of a certain size. I want to add a button that will duplicate blank versions of the input sheets and name them sequentially so that the user can add more data if necessary (currently the user is having to copy & paste the three worksheets and then delete the contents to start again).
Can anyone offer any insight into this?

Thanks in advance

[Kaper]

Store empty templates in separate file.
Once needed, both files shall be open, and user should select all three worksheets in template, right clichk on one of selected tabs, from pop-up menu select move or copy, select original file as destination, at the bottom check "make copy" and select "and after last one" in the middle.

Registered macro (stored in template file) can be used as a base for your own:

Please Login or Register  to view this content.