Can a cell show the worksheet tab value?

My worksheet tab and my title cell in my worksheet must have the same
value. can one read the other so I only have to input the information
once?

Thanks

Wally

Wally, have a look here, http://www.xldynamic.com/source/xld.xlFAQ0002.html

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

"Wally" wrote in message
...
Can a cell show the worksheet tab value?

My worksheet tab and my title cell in my worksheet must have the same
value. can one read the other so I only have to input the information
once?

Thanks

Wally

Hi Wally,
See my http://www.mvps.org/dmcritchie/excel/sheets.htm
page for questions on sheets
see my http://www.mvps.org/dmcritchie/excel/pathname.htm
page for questions on extracting pathname, workbook name, sheetname

VBA cell value gets worksheet tab value
range("a1") = application.activesheet.name

VBA worksheet tab gets cell value
ActiveSheet.Name = Range("a1")

you might also be interested in formatting with a date (with or w/o the prefix)
ActiveSheet.Name = "D" & Format(Date, "yyyymmdd")
ActiveSheet.Name = "D" & Format(Range("a1"), "yyyymmdd")
ActiveSheet.Name = "D" & Format(Range("a1"), "yyyy_mmdd_hhmm")

worksheet function cell value gets worksheet tab value
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
« The CELL formulas with "filename" will not work until the file has been saved (#VALUE! error).
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Wally" wrote in message ...
Can a cell show the worksheet tab value?

My worksheet tab and my title cell in my worksheet must have the same
value. can one read the other so I only have to input the information
once?

Thanks

Wally

and since you don't care which you change, you should be
changing the sheetname, because you can't have two sheets
with the same name so that would be the easiest way to go
and not have to worry about intercepting errors.

Hi,

Try,

Define *X*

=GET.DOCUMENT(76)&T(NOW())

Now in the cell,

=MID(X,FIND("]",X)+1,255)

Note: It works in an unsaved workbook also.

See 'here also'
(http://www.ozgrid.com/forum/showthre...highlight=nice)

HTH


--
Krishnakumar


------------------------------------------------------------------------
Krishnakumar's Profile: http://www.excelforum.com/member.php...o&userid=20138
View this thread: http://www.excelforum.com/showthread...hreadid=391622