Hi
I need to have a drop down list and for the selected value to be used to take me to the cell, on the same sheet, that contains that value.
I have searched every where on the site but cannot find a solution
Thank You
Hi
I need to have a drop down list and for the selected value to be used to take me to the cell, on the same sheet, that contains that value.
I have searched every where on the site but cannot find a solution
Thank You
Welcome to the forum.
You certainly won’t be able to do this without VBA - shall I move the thread for you to that section?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
You cannot do this directly from the DD, but you could do this with a helper cell.
If your DD is in M4 and contains regular cell refs (A1, G5, K10 etc)
you could put this in a cell next to it, it will provide a clickable hyperlink to the cell you select...
=HYPERLINK("#"&M4,M4)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Ali - Thank you.
Please move this to whatever you is the best section.
I was hoping to avoid VBA, but expect it is the only way
Regards
N
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks