Copy hyperlink from one cell to another in the same row

[Louise Mason]

I need to copy the hyperlink which attached to one cell onto another cell in an adjacent column in the same row


Looking for a function to

(a) search column L1 to L200 on each worksheet in the workbook
(b) check if e.g. L1 has a hyperlink
(c) if so copy the hyperlink
(d) add the hyperlink to another cell in the same row e.g. K1 (cell K1 already has text which needs to remain as is)

any help appreciated

Thanks.

[FDibbins]

what is contained inthe hyperlink?

could you upload a sample workbook please?

[Louise Mason]

Somewhat late but hoping to find a solution for this summer.

Sample sheet attached.

We have up to 20 itineraries using codes for each item.
Using VLOOKUP to get descriptions

Either
Copy the hyperlink during the Vlookup process

OR
Copy the hyperlink from L column (that was the nearest I could get it - I had to manually add the links to J column last year)


Any help to improve the clumsiness welcome
Louise