I am linking many different cells from over 100 seperate files. As the cells
appear in the same location on each file I would like to know if I can join
text in serveral cells to create an external link rather than going into
every file and manually link each cell ?

Thanks Rob