Find and Replace the character in a substring.

Hi,

I have attached the 2 workbook, master & transaction. From master workbook column F column name "EXIST DOCUMENT" values need to find in the transaction workbook column D column name "Documents". If match found in the column D substring field, it need to replace with column G column name "NEW DOCUMENT" value from master workbook.

The transaction workbook need to be given as input workbook, when the macro is get executed from master workbook.

I have done some coding for that work, marked with red in colour :-

Please Login or Register  to view this content.

The code is also avaliable in master workbook. It would be great if someone help me out.

Regards,
SaiKumar.