djdionysus
New member
- Joined
- Feb 13, 2014
- Messages
- 2
- Reaction score
- 0
- Points
- 0
Hi All. I am new to this forum, and I thought I would ask the experts here about my quandary.
I am currently working on a project to upgrade an inventory spreadsheet. On the spreadsheet there are 2 fields for current inventory in two locations, an Ordered field (for current orders), and a Total current inventory field. The current inventory field formula is currently =A1+B1-C1.
The issue I am wondering about is whether or not there would be a way to update A1 or B1 when the value in C1 is deleted.
For example. Currently the total field shows the accurate current inventory with the on order field being occupied (C1). As more and more orders are closed out, the total will change on a frequent basis.
Back to my question. So if an order (C1) is finished, and the value is removed, is there a way to update A1 or B1 when that value is removed.
They are trying to make the process a bit more automated considering the amount of orders that pass through the business on a daily basis.
I have been thinking about possibly using nested if's/and's to do this, but I am struggling a bit.
Any help and/or suggestions would be appreciated.
Brandon
I am currently working on a project to upgrade an inventory spreadsheet. On the spreadsheet there are 2 fields for current inventory in two locations, an Ordered field (for current orders), and a Total current inventory field. The current inventory field formula is currently =A1+B1-C1.
The issue I am wondering about is whether or not there would be a way to update A1 or B1 when the value in C1 is deleted.
For example. Currently the total field shows the accurate current inventory with the on order field being occupied (C1). As more and more orders are closed out, the total will change on a frequent basis.
Back to my question. So if an order (C1) is finished, and the value is removed, is there a way to update A1 or B1 when that value is removed.
They are trying to make the process a bit more automated considering the amount of orders that pass through the business on a daily basis.
I have been thinking about possibly using nested if's/and's to do this, but I am struggling a bit.
Any help and/or suggestions would be appreciated.
Brandon