Hello,
I need some help as I never had any training on excel and I'm lost! I need to retrieve airwaybills with hyperlinks. To do so I have tried a =HYPERLINK(VLOOKUP(F2,exacta!A:N,14,0)) however when I click on the link I get an error message (Cannot open the specified file). I've tried some stuff I found on forum (like creating a VBA (my first one by the way) to get the URL but it only worked the first time so I don't know why I wasn't able to make a secon miracle . Anyway, the url displayed with a 'so the link wasn't working anymore.
So do you have any idea? Thanks a lot in advance
I need some help as I never had any training on excel and I'm lost! I need to retrieve airwaybills with hyperlinks. To do so I have tried a =HYPERLINK(VLOOKUP(F2,exacta!A:N,14,0)) however when I click on the link I get an error message (Cannot open the specified file). I've tried some stuff I found on forum (like creating a VBA (my first one by the way) to get the URL but it only worked the first time so I don't know why I wasn't able to make a secon miracle . Anyway, the url displayed with a 'so the link wasn't working anymore.
So do you have any idea? Thanks a lot in advance