I would be thankful, if some one could give me a lead to over come the
problem faced by me.

I have say 2 files: L1 & L2. Both of them have one key field that
remains same. Now, I need to add few additional columns of data
information in file L1, reading the data from File L2, only if the "Key
data" matches with each other.

Note that file L1 need not necessarily have all the rows of DATA as in
File L2, the Key-field which is unique may not be present in both files
L1 & L2 in as may rows, since the row of information in these two files
are looked at different time frames, deleting the entire row-if certain
other criteria is met.

In short: if Files L1 & L2 are to be compared: and file L1 needs to be
appended information from File L2, Only for those cells if the Key
Field match. The Key field could be in Column B in file L1 and F in
File L2. Actions that need to be taken a

Compare the range of Cells in Column B of File L1 and Column F of file
L2. For every matching data, copies the contents in corresponding row’s
cell data in file L1, in the appropriate column.



June 19, 2006


--
Sreeraman.TS
------------------------------------------------------------------------
Sreeraman.TS's Profile: http://www.excelforum.com/member.php...o&userid=26234
View this thread: http://www.excelforum.com/showthread...hreadid=553185