![]() This can be handy for navigating through a spreadsheet with lots of sheets. =INDEX(SheetNames,A2)Īs a bonus, we can also create a hyperlink so that if you click on the link it will take you to that sheet. In a sheet within the workbook enter the numbers 1,2,3,etc… into column A starting at row 2 and then in cell B2 enter the following formula and copy and paste it down the column until you have a list of all your sheet names. Enter the following formula into the Refers to field. ![]() There are 50 sheets in this example so I was lazy and didn’t rename them from the default names. In this example, I’ve created a workbook with a lot of sheets. For this trick we’re going to use one of these in a named function. These functions aren’t like Excel’s other functions such as SUM, VLOOKUP, INDEX etc. These functions won’t work in a regular sheet, they only work in named functions and macro sheets.
0 Comments
Leave a Reply. |