how to get a link to follow a relocated cell address

[MrDB4Excel]

The attached images of excel files give a full explanation of what I am looking to do. Essentially to get a cell address based on the adjacent cell's content and deliver that cell address. Then to have a formula update automatically to provide a link to said cell address as it changes due to insertion of new rows. See the attached and hopefully, it will be enough to understand what I am looking to do.

 

[teylyn]

The screenshots have black background and curly fonts. Really hard to read. Can you repost with standard Excel settings that are not so hard on the eyes? It's hard to figure out what's going on here.

 

[MrDB4Excel]

Okay, I will get right on it.
￿￿
￿￿
I tried using this XL2BB. If this doesn't work let me know. Much simpler if I could simply upload a very simple excel xls file, but hey I can't fight city hall.

 

[mikerickson]

Perhaps something like

Cells.Find("searchTerm").Offset(0,1).Name = "myCell"

then the formula =myCell will follow it around as per insertions, deletions and CUT/pastes.

 

[MrDB4Excel]

When it comes to VBA I have nightmares, but hey I will give it a try. Thanks

 

[MrDB4Excel]

Looking at this code causes blank stares. Not really sure how to get it to work.
I must be brain dead or blind in one eye and can't see out the other.

 

[Fluff]

I tried using this XL2BB. If this doesn't work let me know. Much simpler if I could simply upload a very simple excel xls file, but hey I can't fight city hall.

Have a look here & scroll down to the bottom
XL2BB