I have a 4 folder with approximately 24,000 files. I need to be able to retrieve the value of Cell G8 for each of these files and paste it and the file name into a excel spreadsheet
is it possible to create a routine for this?
I need to search for a content inside 5- 6 closed excel files, but these files are in different sub folders.
For e.g.
1. Assume a folder named Test on the desktop containing 2 sub folders- Survey1 and Survey2
My excel files will be present in either of these folders .
\\Test\testfile.xlsx
\\Test\Survey1\Survey1file.xlsx
\\Test\ Survey2\ Survey2file.xlsx
2. I need to search for text e.g. “Brakes” inside any of the cells of these excel files. The output should return me content from two columns of these excel files, namely “Summary”, “Address”. Position of these columns is not fixed in either of the files.
E.g.“Summary” could be at cell C1 of testfile.xlsx OR E1 of Survey1file.xlsx
Similary, Address” could be at cell C4 of testfile.xlsx OR K1 of Survey1file.xlsx
Can we write a macro/ routine to help me achieve the above?
Regards,
TKExcel
is it possible to create a routine for this?
I need to search for a content inside 5- 6 closed excel files, but these files are in different sub folders.
For e.g.
1. Assume a folder named Test on the desktop containing 2 sub folders- Survey1 and Survey2
My excel files will be present in either of these folders .
\\Test\testfile.xlsx
\\Test\Survey1\Survey1file.xlsx
\\Test\ Survey2\ Survey2file.xlsx
2. I need to search for text e.g. “Brakes” inside any of the cells of these excel files. The output should return me content from two columns of these excel files, namely “Summary”, “Address”. Position of these columns is not fixed in either of the files.
E.g.“Summary” could be at cell C1 of testfile.xlsx OR E1 of Survey1file.xlsx
Similary, Address” could be at cell C4 of testfile.xlsx OR K1 of Survey1file.xlsx
Can we write a macro/ routine to help me achieve the above?
Regards,
TKExcel
