Copy hyperlink in another sheet when using vlookup [Closed]

Report
Posts
13
Registration date
Thursday July 27, 2017
Status
Member
Last seen
August 29, 2017
-
Hello guya please help.

I have little knowledge in vba.

i have an employee details in sheet 1 and i have a vlookup fromula in sheet 2 to show the id number, visa number and passport number.

The id number, visa number and passport number are in hyperlinks that show the jpg file of the id, visa and passport.

Is there a vba code that when i use the vlookup formula in sheet 2, the id, visa and passport numbe will appear in hyperlink which also shows the jpg file just like in sheet 1?

Please help.

Thank you