Copy worksheet contents to new worksheet

[shotta]

I am trying to copy a sheet named template which has all the column headings but no data, to a new sheet on daily basis. Each day it should copy the the template to a new tab and rename the tab to the current date, then hide the previous days (tabs). I got the code below to rename the tabs however when it copies the template it doesn't copy the template with the columns it just highlight the cell ranges on the new worksheet.

Please Login or Register  to view this content.

[JBeaucaire]

One approach:

Please Login or Register  to view this content.

[watersev]

hi shotta, if to leave everything as is, amend this line to:

Please Login or Register  to view this content.

[shotta]

Thanks alot.I have a sheet name Total that's suppose to add up the values for each spreadsheet. Once i open the excel file it hides the 2010831 file, that was the spreasheet which the total are calculated from, however, each day a new sheet is created i would like to calculate those totals too. The sheets copied from the template should all be in the same position once they are created. I would like to calculate the totals for all 10 columns the below code only calculate one column (SURGICAL DENTURES) where do i place the Else if statement to add the others. You can view the attached to see what i am doing Please advise

Please Login or Register  to view this content.