Comparing cell values of different workbooks

[twckfa16]

Hello -

I have three files already opened. One to execute macro from, the other two I want to:
1) select from A2 to the last cell in the wm file and sort by prog in column G
2) Basically compare columns G and I in req file and wm file....if there is
a match, store the value in column A from wm file in arr

Here is the code I have - a lot I know is missing:

Please Login or Register  to view this content.

Thank you -

[twckfa16]

Hello -

Just realized my description is probably not so good.

1) Sort Column G in the wm file.
2) Start with the second row in the file named req...Is there a match with anything in the wm file in columns G and I in both files?
If so, pick up the value in column A in the wm file and store in arr.
If not go to the next row in the req file

Hope that helps

Thank you!