• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Duplicate multiple worksheets

J

jk51

Member
Hi,

I have an excel file containing 1 worksheet only. This worksheet contain table template and i want to duplicate this sheet 20 times in one go. I don't want to copy one by one using right click sheet , copy and paste.

Is there a quick way of paste the same sheet 20 times or 50 times etc?

Thanks

Mr Singh
 
Mr Singh
I have created sheet based on posted query using VB code. You can see the button in Sheet1 , when you press it will ask how many sheets you want to create, based on input those many will be created. Hope this suit and help your requirement. let forum know otherwise
Please see attached sheet.
 

Attachments

You must log in or register to reply here.
Back
Top