Suite B1 | G&C Apartments | Plot 1314 | Church Road | Ntinda | P.O.Box 72663 | Clock Tower | Kampala | Uganda+256(39)321-5149 +256(77)581-9896email

How to get the name of the current worksheet using Excel Functions

How to get the name of the current worksheet using Excel Functions

Good afternoon Folks,

My world is full of puzzles.

Yesterday, while in Kigali, Rwanda, hunting for business, I received a call from my friend. He was in the middle of creating a business plan checklist when he hit a deadlock. His checklist had a cell that required to automatically show the name of the worksheet (In other words, when a user changes the sheet name, that cell should automatically reflect the changes).

I reproduce, below, my step by step dummy approach to solving his dilemma. I will also include my version of his template which you can download after reading this post. It is a token from my heart.

HOW TO GET THE NAME OF THE CURRENT WORKSHEET USING EXCEL FUNCTIONS