Dynamic Hyperlinks

[crayfordsean]

Hi,

Just joined this forum and have tried searching for what I need but no luck. Apologies if the answer is out there.

I need to create Dynamic Hyperlinks as follows :
I have a summary listing on 1 tab and want to Hyperlink to a detailed listing on a different tab on the same workbook.
i.e. The listing on tab 1 shows :

A/c Number
A/c Name

etc ...

The details on tab 2 show :

A/c Number
123
345
678
999
A/c Name
Smith
Jones
Patel
Lee
etc ...

I want to create a Hyperlink so that when I click on "A/c Name" on tab 1, it takes me to the corresponding cell on tab 2 but such that
when the details on tab 2 are updated and more lines are added/deleted, it keeps track of where it is.

Hoping this can be done via the Hyperlink formula as I don't have VBA knowledge.
Thanks in advance for any assistance.

Sean.

 

[martindwilson]

Excel Workbook
	A	B	C	D
1	ac number	345		link to 345
2	ac name	Patel		link to Patel
Sheet1

Excel Workbook
	A	B
1	ac Number
2	123
3	345
4
5	678
6	999
7
8	ac Name
9	Smith
10	Jones
11	Patel
12	Lee
Sheet2

 

[crayfordsean]

User communities never fail to impress me !! Thank you very much Martin. Works a treat.