Compare characters in two columns

[enhydra]

Hello,
I have 2 worksheets in two different workbooks (wb1 sh1 and wb2 sh1). I want to run a macro from a third workbook that compares the time stamp in Column A with both worksheets if matches then compare first 4 characters of column B wb1 sh1 with column B wb2 sh1. If they match then copy the last 3 characters from Column B wb2 sh1 to the end of the data in column B wb1 sh1 (append to existing characters). I need this to loop thru each row until empty. The example below is just a simple example so I cannot just copy one column to another. Any help would be appreciated. Also, I need to run a macro from a third workbook because to first 2 workbooks do not exist until other parsing code finishes.

Thx
E.


Existing:
Wb1 sh1 column A and B
16:00:00 700E
16:00:00 800G
16:00:00 900H

Wb2 sh1 column A and B
16:00:00 700E(A)
16:00:00 800G(B)
16:00:00 900H(C)

Results:
wb1 sh1 column A and B
16:00:00 700E(A)
16:00:00 800G(B)
16:00:00 900H(C)

[arlu1201]

You mean - just the brackets and the alphabet within needs to be appended right?

[enhydra]

That is correct.

[snb]

Please post a sample workbook and the code you have managed to write this far.