Improve Time to Copy Worksheet & VBA to delete Columns

[jewkes6000]

I have a workbook where I've created a template on one worksheet called "Master Cost Tracker". The idea is to create a copy of this worksheet every time you have a new version of a cost tracker. The problem is that it takes about 30 seconds to copy this worksheet. There are a lot of formulas on this worksheet which may be why it's taking so long to copy. I have a macro which copies the worksheet, then deletes any rows/data which are not needed for that particular version; however, it doesn't matter if you copy the sheet through VBA or manually, it's takes a very long time either way. Here is a link to the workbook.

In the macro "Create_New_Cost_Tracker", after copying the worksheet template, the macro deletes columns not needed. This portion of the macro also takes a very long time.

Any help or ideas on improving the performance would be much appreciated.

Here is a link to the workbook:

Improve Time to Copy Worksheet (Mr Excel).xlsm

drive.google.com

 

[jewkes6000]

I just found out that be changing my macro code to hide the columns rather then deleting them, it significantly improved the performance. It took about 30 seconds to deleting the columns and about 2 seconds to hide them.

Now I just need to figure out how to improve the performance in copying the template worksheet????