Immatoity
02-07-2009, 05:07 AM
If you create a list like so
=MID(CELL("filename",'worksheet 1 name'!A1),FIND("]",CELL("filename",'worksheet 1 name'!A1))+1,255)
for each worksheet. You have to put the name in for the first time, but every time it gets updated, so does your formula.
xld..sorry but I need use of this ..however I create a sheet called summary and I want it to list all the tab names ( can be various) below each other in the one sheet called summary..will this work
=MID(CELL("filename",'worksheet 1 name'!A1),FIND("]",CELL("filename",'worksheet 1 name'!A1))+1,255)
for each worksheet. You have to put the name in for the first time, but every time it gets updated, so does your formula.
xld..sorry but I need use of this ..however I create a sheet called summary and I want it to list all the tab names ( can be various) below each other in the one sheet called summary..will this work