Quick Create Excel New Sheets With Default Template

With VBA, it is much easier to create new excel sheets in just one click. This tutorial covers how to create new sheet with your default template. In most of applications you have excel forms which you create for every guest, user, or customer so every time you have to copy and erase all filled data. This VBA code makes your life more easy and saves lot of time. It has feature to copy your default template into new sheet and erase all filled data with just one click. Checkout complete video and apply it in your excel application. 

• Goto developer option in excel 
• Inside developer tab, insert command button
• Copy and paste below code inside command button function 

Download Code From Here:  Download Here

Let's discuss How this code is working:

• I have defined variable a in which cell value at row 5 and column 13 is saved. This means what ever you write at cell(5,13) will be name of new sheet.
• Activesheet.copy function copies excel template or sheet and sheet.counts counts the total number of sheets. so after copying it moves new sheet to last sheet not at middle or beginning of sheets.
• ActiveSheet.Name basically changes sheet name which is defined in cell(5,13).
• and in the end, clearcontents erases the filled data of your sheet. it only leave template. you can define multiple ranges to erase different data at different cells. 

Watch Complete Tutorial on YouTube