Hello all,

I have a macro that will add hyperlinks to a worksheet from .xlsm files found in subfolders
I need to reference certain cells in those files. I have tried a few different methods to no avail.

Is there an easy way to look at a hyperlink in cell B2 (without opening) and paste the value of cell C5 from that external workbook into cell B9 of this workbook?

I already have variables to go with which column the hyperlink is located and the cell references will change for all of the information I need to put in, but if I can learn how to do one, i can go on for the rest.

Thanks a lot for any help I can get