Multiple times paste

[max1995]

Hi All,

I Will try to attach the file in question.

It's pretty much the same as the first request,all in the same workbook.
I Frequently create new sheets within the same workbook , the first sheet (master) is the blank template
I Copy this template , create a new sheet within the same workbook and paste this template multiple times (ranges from 20-30) times and some times even more

The idea here is that I Want to automate this process so once I Create the new sheet and enter the number of times in a specific cell I Want the template to be Pasted, It's pasted on that new sheet.

P.S I’m a newbie to VBA

any advice would be much appreciated.

Here's the link to the excel file : Template.xlsx

BR,

 

[Fluff]

You're welcome & thanks for the feedback

 

[An Quala]

Hi, I am also using this VBA code for similar purpose but VBA is getting break and not working, please let me know the issue, thanks.

 

[Fluff]

You will need to start a new thread for this question.
When you do please post the code you are using & explain where it is going wrong & what errors you are getting.
How to Post Your VBA Code

 

[An Quala]

I just posted a new thread.