Combining the solutions of two previous posts

Hi all,

I once again need your assistance. I have posted some problems and you gave me the code for solving these problems, but it would be great if I could combine the codes of both problems.

The first problem is located here: http://www.excelforum.com/excel-prog...28#post3159028
The second problem is located here: http://www.excelforum.com/showthread...t=#post3159671

The idea is to integrate the second code into the first code. Hence, instead of using predefined cell locations, the code has to search (in each opened file in sheet 1) for certain 'keywords' and returns the result (which is a cell adjacent to the keywords) back to sheet 2.

Is this possible or am I asking for too much?

Your assistance is greatly appreciated.

Regards,
Martijn

Hi All,

Can nobody help me with this problem?
I have tried to copy the solution of the second problem into the first code, but that doesn't work.

Please Login or Register  to view this content.

Regards,
Martijn

Can nobody help me? There must be someone who knows to solve this problem .