madocar Member Monday at 7:32 PM #1 Hello, please, I have 1 Folder with more than 2 000 Excel workbooks. I need to get value from each of them - cell B4 and B7. Is there any way how to do that? INDIRECT function does not help as far as I know - it does not work if the workbook is not open. Thank you for any help
Hello, please, I have 1 Folder with more than 2 000 Excel workbooks. I need to get value from each of them - cell B4 and B7. Is there any way how to do that? INDIRECT function does not help as far as I know - it does not work if the workbook is not open. Thank you for any help
AlanSidman Well-Known Member Monday at 8:46 PM #2 This video should get you on the right path. Of course you will need to modify it to only grab your selected cells.
This video should get you on the right path. Of course you will need to modify it to only grab your selected cells.
