View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default How to update one manually-entered value from another?

Hi!

See this:

http://mcgimpsey.com/excel/accumulator.html

Biff

"1robc57" wrote in message
...
I have a cell (E5) which represents a manually entered value "Inventory"
(say
10), in J5 the user enters 5 to reflect "Damaged Inventory Discarded". I
want
E5 to decrement by this J5 value to reflect the correct inventory value of
5.
How is this done/what function or for,ula.
Thanx - rc