Loop through all worksheets in all sub-folders and enter name and number in A2 and B2 base

[rakesh933]

Please help !

I want the macro to go through all the files in a sub-folder and look-up the file names mention in the another excel sheet "Sample 1", and open and paste the "name" in "A2" and "no" in B2.

"Sample 1",

A B
name no.
Central 5656
Sustainable 5454
Ancilliary 2151
Directorate 57825
Product 5458



thanks in advance

[davesexcel]

There are dozens of threads on this topic in this forum, use the search box. You can also check here on code to loop through folders.
http://www.davesexcel.com/apps/blog/...r-of-workbooks
When you need assistance with the code, then post back with a specific question.