| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can you make a drop down list in a drop down list? | Excel Discussion (Misc queries) | |||
| Make drop down list in larger font | Excel Discussion (Misc queries) | |||
| Need to make a drop down list of 3 items that input a value in ano | New Users to Excel | |||
| multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
| How do I make other cells dependent on my drop down list? | Excel Discussion (Misc queries) | |||
Threaded Mode
