Need to copy a certain sheet to the amount of the value on InputBox

Good day All,

Hope you can help me!!! I have a sheet named template and index sheet. WHat i am looking for is on the index page i have a button that when you click it it opens a Input Box asking how many copies of the template you require. Lets say for example you put in a qty of 5 then the vba code needs to make a copy of the template and paste it 5 times on the same tab bar.

Hope somebody can help me this is quite urgent.

Regards
Wes

Vikas Verma's picture

Please visit