|I don't think you need a macro.|
As long as the bond names match exactly, you can use VLOOKUP.
Read the Excel Help file on VLOOKUP. If you have any questions, come on back and we'll see what other help we can offer.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.