Hello! I’m have a workbook with many data entry tables, each in a separate worksheet in the workbook. I need to set up a directory with a list of each of the ‘Tabs’ that will function as a hyperlink which sends the user to the last open cell in the table of the specified worksheet.

I’ve tried one suggestion that I couldn’t get to work correctly. Namely, by creating a ‘dummy’ named range pointing to a cell on order to get the hyperlink established, and then using the following formula to return the correct worksheet. I’ve tried using the INDIRECT(ADDRESS(XMATCH formulas without any success. Any assistance would be helpful. Thank you! 

​Hello! I’m have a workbook with many data entry tables, each in a separate worksheet in the workbook. I need to set up a directory with a list of each of the ‘Tabs’ that will function as a hyperlink which sends the user to the last open cell in the table of the specified worksheet. I’ve tried one suggestion that I couldn’t get to work correctly. Namely, by creating a ‘dummy’ named range pointing to a cell on order to get the hyperlink established, and then using the following formula to return the correct worksheet. I’ve tried using the INDIRECT(ADDRESS(XMATCH formulas without any success. Any assistance would be helpful. Thank you!   Read More

​