View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bonnie Bonnie is offline
external usenet poster
 
Posts: 82
Default i enter value in one column the next column existing value turn 0

I am working same work sheet with two columns one is Anticipated Variation
cost and the other approved variation with corresponding total. when i enter
cost in approved variation the corresponding row in anticipated variation
column should auotmaticlly become zero.cna you help me out with the formula
to use