![]() |
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