Hello,
I got about 100 excel files that are tables converted from PDF.
They contain two data I am interested in copy in a unique file.
I would like to use a macro that:
1) goes through different files
2) searches for two specific words
3) copies the cell adjacent to the right of the two words I look for.
The cells I want are placed in different positions through all the different files.
I tried to add few lines in the following code, but no success... Searching Through Many Workbooks (Microsoft Excel)
Thanks a lot, to those who will help me![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
I got about 100 excel files that are tables converted from PDF.
They contain two data I am interested in copy in a unique file.
I would like to use a macro that:
1) goes through different files
2) searches for two specific words
3) copies the cell adjacent to the right of the two words I look for.
The cells I want are placed in different positions through all the different files.
I tried to add few lines in the following code, but no success... Searching Through Many Workbooks (Microsoft Excel)
Thanks a lot, to those who will help me