List All Sheet Names In Excel Workbook Without VBA|Excel:Create an automated list of worksheet names

List All Sheet Names In Excel Workbook Without VBA|Excel: Create an automated list of worksheet names

#CTTUTORIAL #EXCEL #GETSHEETNAME #BASICEXCEL
In this tutorial I show you how to create a list of All sheet names in any workbook by using a Macro language function (=Get.Workbook) inside a Defined name. I will then combine the Defined name with an INDEX function, a ROW function, a REPLACE function and an IFERROR function.
Then we create a Forward and Backward Navigation from the Index of Sheets to any other sheet and back, using a HYPERLINK function.

Follow me on :

Subscribe to this Channel!

PLAYLIST:

microsoft excel,return sheet name,display sheet name,cell function,mid function,find function,excel formulas,excel functions,computergaga,alan murray

[nurulhasanmiddya]

Thanks #CTTUTORIAL, I was looking for a video like this .

[vaidhianathankrishnamoorth]

Formula is not visible. If you can zoom in and show the formula it will be useful.