Hi,
I have about 55 excel workbook templates (identical format; different info) from which I need to extract specific cells into a common worksheet to collate all the information. I have seen, in the past, a macro that lists the links to a specific cell in a number of workbooks saved in the same folder, once you have selected the folder where the workbooks are stored; Once the links are displayed you simply change the cell reference and copy/paste in the next column for all the others in same folder and hey presto you have the values for the same cell from all the templates. Has anyone come across this? Or help out in any way? Your help is very much appreciated
Thanks