Want to make a drop down list that deducts from another sheet?

C

crowraine

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top