Navigation menu with hyperlinks

[tigerzen]

I've got a new computer so I've installed the XL2BB add-in but I can't get the capture range feature to work. Anyway, I'm trying to create a navigation menu where the menu options are hyperlinked.
The hyperlinks fail when rows are added/deleted, I'd also like to move the range that the hyperlinks are attached to move just underneath the menu options. Can this be done without VBA?

 

[bobsan42]

the hyperlinks don't fail when you add/delete rows - they just lead to the same cell address, but different then you expect - it doesn't get adjusted like formulas do. so you will need a way (some function) to locate the cell you need , then build an address string and plug it into a HYPERLINK function (rather than using an actual hyperlink). Something like:

=HYPERLINK("[.\]'Sheet2'!A1","text to display")

I didn't understand the moving part of your question.

 

[tigerzen]

Thanks bobsan, I'll add a file to provide context.

Hyperlinking.xlsx
	A	B	C	D
1				Project
2				Governance
3				Consultation
4				Reporting
5				Evaluation
6
7			Project
8				Element 1.1
9				Element 1.2
10				Element 1.3
11				Element 1.4
12				Element 1.5
13				Element 1.6
14				Element 1.7
15				Element 1.8
16				Element 1.9
17				Element 1.10
18				Element 1.11
19				Element 1.12
20			Governance
21				Element 1.1
22				Element 1.2
23				Element 1.3
24				Element 1.4
25				Element 1.5
26				Element 1.6
27			Consultation
28				Element 1.1
29				Element 1.2
30				Element 1.3
31				Element 1.4
32			Reporting
33				Element 1.1
34				Element 1.2
35				Element 1.3
36				Element 1.4
37			Evaluation
38				Element 1.1
39				Element 1.2
40				Element 1.3
41				Element 1.4
42				Element 1.5
Sheet1

I'd like once the hyperlink is selected to sit just under the Frozen navigation menu eg click on Reporting and it moves to the top ie where C7 would be. At the moment, click on Reporting hyperlink and it picks it up but the cell pointer moves to C32 which is at the bottom of the screen, I'd like to have more of the Reporting up higher on the screen. For context,

does the job but uses VBA, VBA won't be on option for me on my work computer so 'll have to find another way.