Afternoon All,
I'm trying to create a way to have my master file lets call it file1 have hyperlinked connections to some of my other files lets call it file2 with the file2 document number that will be in cell D2 to be the name displayed as the hyperlinked name. However It would be really good if file2 could find its document number located in column A of file1 and automatically hyperlink that cell to file2 location. I would appreciate any help on this as I've been looking around for a while and have fallen quite short.
Thanks In advance.
I'm trying to create a way to have my master file lets call it file1 have hyperlinked connections to some of my other files lets call it file2 with the file2 document number that will be in cell D2 to be the name displayed as the hyperlinked name. However It would be really good if file2 could find its document number located in column A of file1 and automatically hyperlink that cell to file2 location. I would appreciate any help on this as I've been looking around for a while and have fallen quite short.
Thanks In advance.
