Forum Discussion
Solved
Rename Cell to Various Different Sheet Titles
Hi, I am trying to create a formula that allows me to have cells equal to the names of different sheets. I have read several interesting posts that created solutions for having a cell automatical...
You can achieve it without VBA coding. Try the following in name manager and call that name to any cell. See the attached file.
Important Note: You must enable Excel 4.0 Macros from macro settings.
=TEXTAFTER(GET.WORKBOOK(1)&T(NOW()),"]")
If you are on M365, you can use this lambda formula, which does not require saving the file as macro-enabled file: https://jkp-ads.com/articles/excel-lambda-function-examples.aspx#name_of_worksheet_in_cell