Hyperlink question

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.

:confused:
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

Forum statistics

Threads
1,207,095
Messages
6,076,552
Members
446,213
Latest member
bettigb

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top