template new sheet

Hello Everyone, I am trying to generate an All-in-One sheet which will auto-populate templates as sheets based on the product type chosen. Currently, we share a single Google Drive folder containing 450 templates, and they chose which to download and enter values. Each of those excel files...

Hi I'm new to this forum so hi :) from me and I hope you are fine. I'm using a spreadsheet which uses an excel template. I've saved the templates as book.xlxt and sheet.xltx to my %appdata%\Microsoft\Excel\XLSTART folder so that this spreadsheet always creates the same template worksheet when...

Hello, I have played with this and still can't figure it out. I have connected this macro to a check box: Sub copy_Sheet() Dim wb As Workbook Dim activeWB As Workbook Dim FilePath As String Application.ScreenUpdating = False Application.DisplayAlerts = False...

Hi All, I have a workbook that has a master project worksheet page ("MAIN") that is a summary of all individual projects worksheets. On the main page I want to assign code to a button that will add a new worksheet that is a copy of a template worksheet within the same workbook ("TEMPLATE")...