I'm having a problem with this solution -- it seems the hyperlinks are too
much when I'm trying to duplicate pages and make changes -- I need to make
links that are absolute within the sheet itself and don't refer to
files\sheets

ie. I want a link that points specifically to a cell within the sheet but is
not relative to any location. Also I want to be able to make a macro that
allows me to create several links on a page so that I can apply that macro to
many other pages -- this won't work with the way 'hyperlinks' seem to work in
excel - can anyone help?