Insert worksheet
 

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 game# = count tabs
+1

This would require VBA programming, specifically an event macro triggered by
changing worksheet "a".

On Sun, 9 Jan 2005 21:15:02 -0800, 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 game# = count tabs
+1