NickCourtney6
New Member
- Joined
- Sep 27, 2023
- Messages
- 6
- Office Version
- 365
- Platform
- MacOS
Hello, I've tried this many different ways. I have in Column A a drop-down list of statuses:
When "Denied" is selected I want specific monetary cells within this row to equal zero but do not clear the content of the whole row. I would like to do this automatically once Denied is selected. However, if it must be a button, I'm okay with that too. Any help is greatly appreciated.
Requested |
Pending |
Approved |
Denied |
Purchased |
Received |
Verified |
Status | Quantity Requested | Quantity Approved | Gear Name | Unit Cost | Ext Price | Other Costs | Other Costs Price | Shipping Costs | Estimated Purchase Date | Estimated Subtotal | Link |
Requested | 2 | 2 | Blackmagic Decklink 8k Pro | $745.00 | $1,490.00 | case | $200.00 | $10.00 | 10/1/23 | $1,700.00 | www.yahoo.com |
When "Denied" is selected I want specific monetary cells within this row to equal zero but do not clear the content of the whole row. I would like to do this automatically once Denied is selected. However, if it must be a button, I'm okay with that too. Any help is greatly appreciated.