amrinderminhas
New member
- Joined
- Mar 25, 2014
- Messages
- 12
- Reaction score
- 0
- Points
- 0
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.)
Figure1

Figure2

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.)
Figure1

Figure2
