Hyperlink to a specified row and column in a matrix hash

[Roncondor]

I have a spreadsheet with a range name matrix

The first row of matrix is the Year # and each row is a different category with many subcategories. See Below

2000 2001 2002 …
Insurance
Health
Auto
Fire
Theft
Utilities
Electric
Gas
Sewer
Phone
Cable
Water
…
…
…
…

I want to set up dynamic hyperlinks so that for which ever year I am in I can go directly to the proper category.

I know that the hash (#) fives more flexibility.

What I want is to be able to hyperlink to Matrix(Row,Col)

Thanks – first, best answer receives $25 to the non denominational charity of your choice.

 

[martindwilson]

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1						2000	2001	2002	2003	2004	2005	2006	2007	2008	2009	2010	2011	2012
2		Fire	2004		Insurance
3					Health
4		Fire 2004			Auto
5					Fire					xxxxx
6					Theft
7					Utilities
8					Electric
9					Gas
10					Sewer
11					Phone
12					Cable
Sheet2

 

[martindwilson]

put =year(today()) in c2 for dynamic

 

[Roncondor]

Thanks that does work nicely, BUT I was hoping for something that would NOT use the ADDRESS function allong the lines of the VBA code ==> Application.Goto Reference:=Range("matrix").cells(X,Y)

But so far you are the winner!