The text is in cell ranges B9:B200, I'm looking for any cell in that
range that contains the words "Savings Bonds". This string may be
within a larger text like "Savings Bonds Fee Adjustment".
If a cell is identified as having that string then the value of the
cell to the right of it is copied to cell G9, G10, G11, etc. Example:
Search for Text Copy Value
B12: Savings Bonds C12: 2,050.00 G9:
B39: Savings Bonds Redeemed C39: 200.00 G10:
B182: Savings Bonds Adjustment C182: 3.80 G11:
The purpose of this is to quickly identify all Savings Bonds related
transactions and have them summarized (where they can be totalled) in a
section of the worksheet.