Sheet Name

[rhmkrmi]

Hello:How can I link a cell to a sheet name so that each sheet gets updated independetly?Thanks

 

[astridcita]

what do you mean?

to link a cell to another sheet goes (sheet name, exclamation mark, cell)
=Sheet1!A1

 

[rhmkrmi]

Hello:

I mean if the name of a sheet is "Test" I want to get the same value in let's say cell A20, I want to get the name of each sheet somewhere in the same sheet in one of the cells. I want to link the name of each sheet to one of the cells in the same sheet.

Thanks

 

[Jonmo1]

See if this thread helps

http://www.mrexcel.com/forum/excel-questions/28759-get-sheetname-formula.html

 

[astridcita]

you need this formula to get the sheet name


=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)


and to return the whole path


=CELL("filename",A1)

 

[Matt Rogers]

Hello.

List & Hyperlinks

Sub List_Worksheets_1()
Dim i As Long
For i = 1 To Sheets.Count
ActiveSheet.Hyperlinks.Add Anchor:=ActiveSheet.Cells(i, 1), _
Address:="", SubAddress:="'" & Sheets(i).Name & "'!A1", _
TextToDisplay:=Sheets(i).Name
Next i
End Sub