Reading from three workbooks

[Rick_Stanich]

I am trying to populate one of three open workbooks with data from one of the other two open workbooks.

I read data from Columns A and B of wb "1234B Map.xls", this is the map, correlation between two of the work books.
Column A of wb "1234B Map.xls" is the same as Column A of wb "AS9102 1234B.xls" and column B of "1234B Map.xls" is the same as column A of wb "1234B.xls". A map, sort of.

Both wb's "AS9102 1234B.xls" and "1234B.xls" start in row 6. (wb "1234B Map.xls" starts in row 1).

Example 1:
wb "1234B Map.xls" cell A1(=1) and cell B1(=1) then with wb "AS9102 1234B.xls" cell E6 value gets coppied too "1234B.xls" cell E6.

Example 2:
wb "1234B Map.xls" cell A28(=21) and cell B28(=800) then with wb "AS9102 1234B.xls" cell E27 value gets coppied too "1234B.xls" cell E850.

This is hard to explain. LOL

In the end, the data in column E of "AS9102 1234B.xls" needs to be coppied to wb "1234B.xls" column E. The problem, column A of each of these wb's are different.

I love (hate, wanna stick 9 inch nails in my eyes) my job!

Please see attached files.

Any help, hints or tips are appreciated.

[Rick_Stanich]

Deleted by OP

[Rick_Stanich]

http://www.excelforum.com/excel-prog...-too-much.html