Forum Discussion
Solved
Link from Drop Down List to first blank cell on a specific worksheet (same WB)
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 ...
Marcus_Booth Use the HYPERLINK function to create a clickable link to the last used cell in the specified worksheet. For example, with the target sheet name in cell A2:
=HYPERLINK("#"&ADDRESS(COUNTA(INDIRECT("'"&A2&"'!A:A"))+1,1,,,A2))See attached example file...
Marcus_Booth Use the HYPERLINK function to create a clickable link to the last used cell in the specified worksheet. For example, with the target sheet name in cell A2:
=HYPERLINK("#"&ADDRESS(COUNTA(INDIRECT("'"&A2&"'!A:A"))+1,1,,,A2))
See attached example file...
- Thank you all for your assistance with this. The response that I ultimately used is not visible here any longer. I marked it as BEST RESPONSE, but apparently it didn't register. It was provided by Sergei Baklan. in this thread, so I'm not sure what I did wrong. Is there a way to mark it as completed?
Marcus_Booth To avoid confusion, it's best to pursue the answer to a single question in a single thread by providing feedback and clarity as needed. Sergei's response (similar to mine) was posted to your secondary thread found here:
- I see. Thank you for the tip! I will take more care next time. I can see that it's important to keep things organized. I went ahead chose the best response on this one. It was similar and spot on. Thank you again for your assistance, with everything. 🙂
