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