Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I haven't done this but I think you can create a "sheet template" such that
whenever a new sheet is added it will be in template form. Can't tell from your post but you may already be doing this. If so, then all you need to do is automate the insertion of a new sheet and name it. This works for me: Sub AddSheet() Dim ShNum As Integer If Workbooks("a").Range("A1") = "x" Then With ActiveWorkbook ShNum = .Sheets.Count + 1 .Sheets.Add .ActiveSheet.Name = "Game " & ShNum End With End If End Sub "ParTeeGolfer" wrote: Is there a way to automatically insert a new worksheet within a workbook if data from another workbook equals a certin value. the name the tab from the last tab number used. Example: IF a1 in workbook "a" = "x" thn insert new worksheet from c:/templates (template Sheet) in workbook B and name it ("Game" #) where # = count tabs +1 Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How use info in Excel shared worksheets to create new worksheets | Excel Worksheet Functions | |||
How do i assign the ActiveWorkbook.Worksheets to a worksheets object? | Excel Worksheet Functions | |||
Assigning Cells in worksheets to other data in other worksheets. | Excel Discussion (Misc queries) | |||
Sort Numerically Worksheets via VB when creating a new worksheets | Excel Programming | |||
Need code to protect worksheets - amount of worksheets varies | Excel Programming |