ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Want to make a drop down list that deducts from another sheet? (https://www.excelbanter.com/excel-discussion-misc-queries/244221-want-make-drop-down-list-deducts-another-sheet.html)

crowraine

Want to make a drop down list that deducts from another sheet?
 
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.


All times are GMT +1. The time now is 07:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com