Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
automatic change in inventory
HI, I have an inventory list for a device I am building. I want to be able to enter the number of devices I have built in a cell, then have the inventory change to reflect the parts used. The inventory is in column H the number of parts in the device are in column D, and the cell I wanted to enter the number of completed units is J3. So I came up with =H5-$J$3*D5 as my formula and put it in H5, But I want to be able to change the number in the inventory column when a new shipment of parts comes in and putting a formula in the cell doesn't allow me to do this. Any suggestions? David -- davidgcunning ------------------------------------------------------------------------ davidgcunning's Profile: http://www.excelforum.com/member.php...o&userid=37874 View this thread: http://www.excelforum.com/showthread...hreadid=574213 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic Color Change | Excel Discussion (Misc queries) | |||
Automatic Color Change | Excel Discussion (Misc queries) | |||
Change the border color used by Change Tracking | Excel Discussion (Misc queries) | |||
automatic color change in cells using a drop down list | Excel Worksheet Functions | |||
Is there an automatic way to change numbers such as 12312001 t | Excel Discussion (Misc queries) |