Hyperlink format issue.

[transpire]

I've attached a sample file, and I need the 3rd column to still leave the number in the box, but to automatically create a link based on a link template, and the 1st letter of the first name and the full lastname embedded in the link in a specific area.

The first row is how I want all of these to be, but I want this automated if at all possible, to where if we changed the name on column 2, it would update the name in the hyperlink next to it in column 3. Some sort of formula that would automatically fix these.

We would also need to be able to manually manipulate the link the the 3rd column without messing up column 2.

This would be a tremendous help to me.

[Leith Ross]

Hello Transpire,

Welcome to the Forum! As a member, you now have full access to the knowledge and posting tools that make this site unique.

In order to provide you with prompt replies to your questions, there are a few rules we ask that you observe. Please remember to follow these rules when you post as a courtesy to your fellow members, and to those who are volunteering their time, and knowledge.

Readability is key in getting a fast response to your question. You have many tools available to assist you in formatting your post. Any code you post, whether a worksheet formula or VBA code should be wrapped. You can find a list of other HTML format options in the forum rules.

How to Wrap your Code
On the Message window Toolbar you will see the # icon. Select the text you want to appear in a Code Window, and Click the # icon. This will wrap the code for you. You can also do this manually by placing the tag [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] at the end of the last line.

You can read the Forum rules by clicking on the link below.
Forum Rules
If you have any questions, contact me by clicking on my name Leith Ross

Sincerely,
Leith Ross

[Leith Ross]

Hello Transpire,

I have added 2 macros to your workbook which is attached. When you add a name to column "B" it won't create a hyperlink unless there is a value in column "C". You can add a value to column "C" later and then click the check mark on the Formula Bar to create the link. All links can be edited manually.

Macro to update/create hyperlinks

Please Login or Register  to view this content.

Worksheet Event Macro - this will update the hyperlinks whenever the named is changed in column "B"

Please Login or Register  to view this content.

Sincerely,
Leith Ross