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()),"]")
