View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
H. Singh H. Singh is offline
external usenet poster
 
Posts: 5
Default refilling data in same cell after user input in another cell

How can I reduce the value in a cell by certain number which I enter in
another cell.
eg: operator enters value 3 in cell D2 and press enter - I want the value
say 55 in cell B5 to be reduced by 3 and have 3 from D2 to be cleared and 55
becomes 52 in B5.

--
H. Singh