Copy hyperlink in another sheet when using vlookup

eunice3301 Posts 13 Registration date Thursday July 27, 2017 Status Member Last seen August 29, 2017 - Aug 20, 2017 at 08:37 AM
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