Hello

I have two excel file id.xls and amount.xls

ID.xls format

ID Amount
12345 100
54321 200
11111 250
33333 500

Amount.xls format
Column A Amount

Total 12345

Total 11111

Total 33333


I want the macro to find the ID from id.xls and replace the amount from ID into amount.xls, and if it couldn't find the id in amount.xls it has to skip and find the next id till the eof in id.xls

Thanks for any suggestion.