Home |
Search |
Today's Posts |
#1
|
|||
|
|||
HELP...!
I have a workbook that contains stats for my team, each team member as ther
own work sheet, I name each sheet with there name, What i want to happen is when i label the Worksheet Tab with the name of the employee name its Populates in any cell i chose in the work sheet, Thanks Rusty |
#2
|
|||
|
|||
Rustynailed, put this in the cell you want the worksheet tab name in, file
must have been saved =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Rustynailed" wrote in message ... I have a workbook that contains stats for my team, each team member as ther own work sheet, I name each sheet with there name, What i want to happen is when i label the Worksheet Tab with the name of the employee name its Populates in any cell i chose in the work sheet, Thanks Rusty |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|