Hi,

I want to do loop in a folder of many excel files.

For each excel files, I want to loop through a tab and search a name of tab.

In the tab of worksheet I found, I want to find row that has certain title and copy this row to another file with all the return values.


Thank you.

Nanjing