worksheets
 

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