Forum Discussion
Linking to row in a spreadsheet
mathetes Thank you for the response. Attempting to clarify. Hope this helps!
Top of Spreadsheet (using individual text box for the following categories):
- Category "Zone 1" (hyperlink to Row 20)
- Category "Zone 2" (hyperlink to Row 40)
- Category "Zone 3" (hyperlink to Row 60)
Issue:
- If I insert a row below, say Row 22, 24, etc., the hyperlink for "Zone 2" at top of spreadsheet no longer takes me to the "Zone 2" section below.
- I'd like the hyperlink at top to anchor on the corresponding row below (i.e., dynamically sticks with that row regardless of row insertions).
Row 20 - Zone 1 (merged row)
- Row 21 - akjasdlkfjs
- Row 22 - kjkjalkjdfas
Row 40 - Zone 2 (merged row)
- Row 41 - oljdsfkaj
- Row 42 - ljkalsdjflasj
Row 60 - Zone 3 (merged row)
- Row 61 - lkjsadlkfjalkj
- Row 62 - kikekna;kjlkj
I apologize, but I need to ask again if it's possible to attach a copy of the actual workbook. Or just the a sheet containing the dummy data such as you've provided. In particular I'd like to see how you implement that use of a set of text boxes at the top of the sheet, text boxes that contain the hyperlinks.
I'd also ask again for a more complete description not just of the task you're seeking to complete, but a description of the context.....it sounds to me as if there may be a deeper design issue, and therefore there may be a way to accomplish the bigger objectives (what the whole spreadsheet is about in the first place) using a different design.
I've not used hyperlinks within a spreadsheet before, other than to link to websites on "the outside"; let alone a hyperlink within a text box within a spreadsheet. It may be entirely legitimate, but if we can get at the bigger picture side of things, there may be a more straightforward method.
Ok see template attached. You can click on say "Money Movement" at the top and it will take you to the corresponding row/section. However, if you insert a row above Money Movement, it stays with the original cell and does not adjust. Hope this helps. Thank you.
Dave_A30092 I don't know why those links aren't dynamic but I just tested (and found it works) using Named Ranges. So click on the heading where you want to link to and in upper left corner type a
NAME for that location. Here is an example where I named the Sales & Marketing row as "Sales":
Then in the edit link box choose that named location:
mtarler that did it. Thank you!!
