Ok, I've look thought the net and can't yet find an Answer, I think i'll need a macro to work it where i'm more of a Beginner in VBA,
But what i am trying to do is that In Sheet 1 coloum A I have a list of Hyperlink that go to certain Excel spreadsheets.
With in Sheet 2 I have all the details and ID's which will conraspond with some of sheet 1's ID's
I'm trying to Create a Vlookup which will pull from Sheet 1 the Filename. and also the hyperlink
on sheet one is it listed as
91901.xls
at the moment I was just displaying it with Vlookup with a wildcard included =Vlookup("*" & 91901 & "*", Sheet1! A:A, 1, False)
This will bring the file up but when i put Hyperlink in Front it just come up with an error when clicking on it
If anyone can help
Thanks
But what i am trying to do is that In Sheet 1 coloum A I have a list of Hyperlink that go to certain Excel spreadsheets.
With in Sheet 2 I have all the details and ID's which will conraspond with some of sheet 1's ID's
I'm trying to Create a Vlookup which will pull from Sheet 1 the Filename. and also the hyperlink
on sheet one is it listed as
91901.xls
at the moment I was just displaying it with Vlookup with a wildcard included =Vlookup("*" & 91901 & "*", Sheet1! A:A, 1, False)
This will bring the file up but when i put Hyperlink in Front it just come up with an error when clicking on it
If anyone can help
Thanks