| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
can i insert the name of the worksheet into a field?
wanting to set up some excel templates - can i insert the name of the
worksheet into a field so that I don't have to rename every tab plus every field each time I use the template |
|
#2
|
|||
|
|||
|
One way:
=REPLACE(CELL("filename",A1),1,FIND("]",CELL ("filename",A1)),"") Note: wb must saved for this to work. HTH Jason Atlanta, GA -----Original Message----- wanting to set up some excel templates - can i insert the name of the worksheet into a field so that I don't have to rename every tab plus every field each time I use the template . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| insert picture in header section of excel worksheet | Excel Discussion (Misc queries) | |||
| Weekly Transaction Processing | Excel Worksheet Functions | |||
| Challenging Charting | Charts and Charting in Excel | |||
| Insert worksheet | Excel Worksheet Functions | |||
| insert worksheet gives me 3 duplicate sheets not one | Excel Discussion (Misc queries) | |||
Linear Mode
