Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Challenging Charting | Charts and Charting in Excel | |||
Indirect reference from one worksheet to another | Excel Worksheet Functions | |||
insert worksheet gives me 3 duplicate sheets not one | Excel Discussion (Misc queries) | |||
Reference Data in Moved Worksheet | Setting up and Configuration of Excel | |||
Insert Month and Year in my worksheet | Excel Worksheet Functions |