Forum Discussion
Rename Cell to Various Different Sheet Titles
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()),"]")
You've gotten a number of proposals for how to achieve what you asked, and if one (or more) of those satisfy you fully, fine.
When I read requests like this--where it's obvious (or seems to be so; forgive me if I'm wrong) that you are creating a sheet for each month of the year--I will often first turn the question back and ask "Why?" Why, specifically, are you designing this workbook with a separate sheet for each month?
I've seen many a time when that approach is undertaken because that's how we did it on paper ledger sheets, so it just makes sense to automate it with the same structure, assuming Excel can make (as it can) the links to summarize from monthly into quarterly or annual reports. HOWEVER, Excel has marvelous capabilities to summarize data on a monthly, quarterly, or annual basis, working from a single database of transactions or activities. And it's generally more straightforward if you do things that way.
Think of it as letting Excel do the heavy lifting. If you've continued the task of "manually" storing data on a month-by-month basis, you're doing a fair amount of work unnecessarily.
So my next question: is it possible that you could benefit from re-thinking the basic design of your workbook. (Just a suggestion. Feel free to totally ignore.)
mathetes​ Sir, nice comment. It is strongly recommended to store data in a single sheet in logical manner and prepare report on the run time as need. All database works on same concept, even file level database like Excel also is suitable to work on same concept. I always suggest my users to thick simply to store data in one place and make report using formulas, filtering's, pivot tables etc.