Hello everyone...
I have multiple number of 'excel' files at present in a folder as shown in figure 1 (in some situations the files can also be pdf or jpg) which i want to get hyperlinked to a new excel file as shown in Figure 2. Now i need that in Figure 2, in Column A (Where there is written Experiment 1, Experiment 2, Experiment 3 and so on...), each cell be hyperlinked with corresponding excel file quickly, instead of me selecting each cell and hyperlinking it with the excel file for all files.

Kindly make the arrangement such that the hyperlinked file can be of any format (i.e.. word, pdf, jpg, avi, mpeg etc.)


Click image for larger version. 

Name:	folder.jpg 
Views:	26 
Size:	62.8 KB 
ID:	2169

Click image for larger version. 

Name:	experiment.jpg 
Views:	20 
Size:	86.5 KB 
ID:	2170