hyperlinks

[swapna sundari via OfficeKB.com]

Hi!
I'm working with excel hyperlinks, i have created two sheets called Application Master and Application Entity Master.In Application master hyperlinks are created pointing to Application Enity Master. If any rows are inserted in Application entity master the hyperlink created in Application Master should automatically point to the related cell in Applciation Enity Master.

*****************************************
* This message was posted via http://www.officekb.com
*
* Report spam or abuse by clicking the following URL:
* http://www.officekb.com/Uwe/Abuse.aspx?aid=fb39734e90344e91b8eb2f4acac547fb
*****************************************

 

[Dave Peterson]

It sounds like you linked to a cell's address.

Maybe you could use a defined name (insert|name|define) and use that in your
hyperlink.