Tompanilla
New Member
- Joined
- Nov 3, 2005
- Messages
- 47
I have a worksheet named Clientregister.
On that worksheet there is the clients names in row C taken from a TOC.
Row D is clients customer number also taken from TOC (='.TOC'!D8)
Row E is client responisble taken from TOC(='.TOC'!G8)
Now to my problem.
I would like to have hyperlinks in row F with the client name taken from the corresponding cell in row C, and so the hyperlink takes the user to the sheet cell C4 for the chosen customer.
The TOC is hidden for users and cant be used by them as they uses the worksheet Clientregister as their TOC
Is there a way to take the name in eg. Cell C14, make a hyperlink of that to a sheet with same name as in C14 and choose cell C4 on that sheet?
As I want the hyperlinks to automatically point to the right sheets the name has to be taken from the corresponding cell in row C all the time.
New clients are coming and The TOC puts them in ascending order and therefore the client names are moving around in row C.
I hope someone has the answer.
It doesnt have to be done by VBA. Idf there is a solution with eg.
=HYPERLINK... I would be happy.

On that worksheet there is the clients names in row C taken from a TOC.
Row D is clients customer number also taken from TOC (='.TOC'!D8)
Row E is client responisble taken from TOC(='.TOC'!G8)
Now to my problem.
I would like to have hyperlinks in row F with the client name taken from the corresponding cell in row C, and so the hyperlink takes the user to the sheet cell C4 for the chosen customer.
The TOC is hidden for users and cant be used by them as they uses the worksheet Clientregister as their TOC
Is there a way to take the name in eg. Cell C14, make a hyperlink of that to a sheet with same name as in C14 and choose cell C4 on that sheet?
As I want the hyperlinks to automatically point to the right sheets the name has to be taken from the corresponding cell in row C all the time.
New clients are coming and The TOC puts them in ascending order and therefore the client names are moving around in row C.
I hope someone has the answer.
It doesnt have to be done by VBA. Idf there is a solution with eg.
=HYPERLINK... I would be happy.