I have worksheet: Total amount.
Column A:
Row 1 Transportation
Row 2 $200
Row 3
Row 4 Medical
Row 5 $200
Row 6
Row 7 Insurance
Row 8 $200

I have worksheet: 000 Registry
row 1: Col. B Description of transaction / Col. C Amount

What I want to do is on worksheet 000 Registry, Column C is to have a drop
down list (Transportation, Medical, Insurance) that I can pick from that will
automatically deduct or add to worksheet Total Amount of row 2, 5, or 8, from
the $200.