Hello, how can I move my cursor from one place (Cell A10 for example) to another (Cell A24 for example) inside the same worksheet? I cannot use hyperlinks because if you insert rows, the hyperlink does not update the cell #. I have a list of table of contents and when the user clicks on the word for the topic they want to read about, I would like the cursor to move to that section.
Welcome to this forum, I hope you'll get the help you want.
Would it be possible for you to attach a sample workbook to your thread so we can work on your actual workbook structure and data?
Thanks
Pierre Leclerc
_______________________________________________________
If you like the help you got,
Click on the STAR "Add reputation" icon at the bottom.
Hi and welcome to the forum
Not sure if this will be a feasible option for you (depends how links you need?), but you could create a named range for the destination, and then use that in the hyperlink...
=HYPERLINK("#"&aa,"this goes to sheet2 A10") Where aa is a named range on sheet2
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
I have attached a sample that might help. I cannot use hyperlinks, because if you insert a line, the cell does not change... unless you know a way to have it update as rows are inserted??
FDibbins is right. You can use named range along with an Hyperlink. In the hyperlink window, you choose, on the left side of the window, the option "Place in this document" and you can choose one of the named range you created. As the hyperlink is referring to a named range, it will follow the target cell even if you add rows or columns.
Can you take a look at the sample excel file I downloaded and tell me what formula I should use?. Because I keep getting an error "cannot open the specified file" when I tried using this formula. Its a new one to me so I am probably typing it wrong. I also tried putting info into the hyperlink window and its not working either.
I tried putting the table of contents and the data on differnet tabs and it still doesnt work. It always goed to the cell or range mentioned in hyperlink. Its not moving to where the data has moved (so if I inserted 3 rows, it doesnt know to change to 3 rows down), unless I am going something wrong??? Maybe Excel cannot do what I need?
If my target is originally cell A36, and I inserted 3 rows, my new target is A39 - and the link still takes me to A36. If the doc was never modified (rows were never inserted) this would work fine, but its a working doc, I am going to be adding info all over this spreadsheet and its huge. I need a fast way to go to the target.
Last edited by DixieDoll11; 02-06-2014 at 12:24 PM.
Ok, here is your workbook modified (I have attached 2 formats: One xlsx and the other is an xls file). I created named range. You can see that by clicking on top menu "Insert" then on "Name" then on "Define". you'll see all named ranges I defined which are pointing to the cells where the specific content starts.
Now, if you click on one of the hyperlink with the right mouse button and then click on "Edit Hyperlink", you'll see how it was configured.
You can insert rows where you want the named ranges will always update their reference cells.
Hope this help
This is awesome!!!! Thank you!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks