Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I show the VALUE in a linked cell?
I have a workbook with several worksheets. In each worksheet, cell H1 is the TABNAME: =MID(CELL("filename",H1),FIND("]",CELL("filename",H1))+1,255). I have a Summary sheet where I want to reference each sheet. Since a user can change the tab names, how can I show the TEXT VALUE in cell H1 and not the formula? Thanks in advance for any help! -- tbitler ------------------------------------------------------------------------ tbitler's Profile: http://www.excelforum.com/member.php...o&userid=25538 View this thread: http://www.excelforum.com/showthread...hreadid=389744 |
#2
|
|||
|
|||
I'm not quite sure what the problem is.
If a user changes the tab name, cell H1 on that tab will be automatically updated to show the new tab name. If the summary sheet is referenced to all the H1 cells, it will be automatically updated as well. -- Vasant "tbitler" wrote in message ... I have a workbook with several worksheets. In each worksheet, cell H1 is the TABNAME: =MID(CELL("filename",H1),FIND("]",CELL("filename",H1))+1,255). I have a Summary sheet where I want to reference each sheet. Since a user can change the tab names, how can I show the TEXT VALUE in cell H1 and not the formula? Thanks in advance for any help! -- tbitler ------------------------------------------------------------------------ tbitler's Profile: http://www.excelforum.com/member.php...o&userid=25538 View this thread: http://www.excelforum.com/showthread...hreadid=389744 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
up to 7 functions? | Excel Worksheet Functions | |||
Only want color to show when cell is active | Excel Worksheet Functions | |||
Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Worksheet Functions | |||
Linked cell location of hyperlink | Excel Worksheet Functions |