Concatenate, Hyperlink Issue

[Ciarmccabe]

Hi All,
I have an issue getting a hyperlink link active.

I have 500+ hyperlinks with sequential numbers on the end of the web address, I have used the concatenate formula to join them together and make the 500 web addresses complete.

I then used the =hyperlink to make the web address a hyperlink.

The issue I have is that I seem to have to click into the cell and press enter to make these links "active" (blue text underlined).

I there any way i can do this last step automatically? or something I should do differently?


Thanks
Ciaran

[JBeaucaire]

I would think you need only do that to the first sequential cell. Then drag that formula/cell downward to copy it and it should update with each row's unique ID and since the original cell was active hyperlink, so should the new ones.

[Ciarmccabe]

Hi Jerry,
Thanks for the reply.


Apologies Jerry, I should add that I also have a macro that when I select the cells it will automatically open the hyperlinks.

Your suggestion will make the the hyperlink formulas active but the macro wont work on the hyperlink formula so I have been copying and pasting as values and using the macro then.

When I copy and paste as values theses are the links that I need active and when I drag the cells down it does make them active hyperlinks but they all take me to the same web address as the first line.

[JBeaucaire]

Let's look at this. Post a small sample workbook with some of these non-working cells and your macro, I'll see if I can help.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[Ciarmccabe]

Hi Jerry,
Ive attached a sample file. The data isn't what I will be using but is similar.

Thanks

[JBeaucaire]

Sorry for the delay.

THis is all you need to create clickable hyperlinks in one go in column C:

Please Login or Register  to view this content.

[Ciarmccabe]

Thanks for this! Much appreciated.