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
Please visit
Hi Dear,
Please visit the following: http://excelexperts.com/solution-need-copy-certain-sheet-amount-value-in...
Thanks