Hi,
I have a problem which i was hoping someone can help with.
I have 2500 MS Excel Files, they are in 11 different folders. (But could be in the same folder).
I need a way to look inside every excel file and return 2 values so i can compare them.
My output would be a single spreadsheet, with 2500 rows (excluding header)
Column A = File Name (without extension)
Column B = Cell E4
Column C = True/False to check if Col A=B.
I do have a formula that will return the filename with no extension into the cell. But I have no idea of how to do this quickly for all files into a single comparison worksheet.
=MID(CELL("filename",A1),SEARCH("[",CELL("filename",A1))+1,SEARCH(".",CELL("filename",A1))-1-SEARCH("[",CELL("filename",A1)))
Please help!!
Thanks in advance
Bookmarks