Automatically create worksheets???

[hardwickj]

Is it at all possible for me to have a sort of "Schema" worksheet, that when someone enters text in one of the cells, excel will create a new worksheet with the name set as the text typed in the schema worksheets cell?

If so, is it possibly to have it create a customized worksheet, sort of based off a default one?

Any help is GREATLY appreciated!!!!

 

[lozzablake]

pretty simple. You can create a macro linked to the change event of the specific sheet. Whenever that cell is altered you can create a new sheet with the name of whatever is in the cell. Alternatively you could copy an exisitng sheet and re-name it. The code below has to go in the module associated with the sheet where the name is typed.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

    If Not Application.Intersect(Target, Range("a1")) Is Nothing Then
        Sheets("Template").Copy after:=Sheets("sheet1")  'change to reflect your sheet names
        ActiveSheet.Name = Target.Value
        
    End If

End Sub