If data added to Excel cell it automatically make's another cell equal zero
 

Hi

I'll try and explain this cos i haven't been very good at searching for
what i want.

Say you have cells 'D1' and 'D8', is there anyway that if i put data in
'D1' 'D8' data is made zero and vice vesa if i put data in 'D8' 'D1' is
made zero.

If anyone can help it would be most appreciated, if you need more
information then please ask i just tried to keep it as simple as
possible

Thanks in advance

If data added to Excel cell it automatically make's another cell e
 

use the worksheet change event
AIR code
if target = D1 then G1 = 0
if Target = G1 then D1 = 0

" wrote:

Hi

I'll try and explain this cos i haven't been very good at searching for
what i want.

Say you have cells 'D1' and 'D8', is there anyway that if i put data in
'D1' 'D8' data is made zero and vice vesa if i put data in 'D8' 'D1' is
made zero.

If anyone can help it would be most appreciated, if you need more
information then please ask i just tried to keep it as simple as
possible

Thanks in advance