How do I show the VALUE in a linked cell?

T

tbitler

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!
 
V

Vasant Nanavati

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change cell color based on another cell value 8
count if equal to not working? 1
Testing for a consistent value counting blanks 1
find all instances of a search item and put result in a single cel 5
Excel How to find the most common pairs and triplets numbers? 5
how do i get data from another workbook 2
Vlookup and return sheet name also 2
using the Cell function 2

Top