View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sal21 sal21 is offline
external usenet poster
 
Posts: 45
Default Compare aumont and insert "Balanced"...

Have this 2 sheet...DARE and AVERE
In the columns I of all sheet are present a value numerical
In D and L other value...
My problem...
With a macro is possible to balance the value (- and +) in I in
inernal of range D and L and insert in AA "BALANCED" if the summ is
=0...
Example:
in line 5 od DARE =-30.463,53 in line 3 of AVERE =30.463,53 this two
value are in internal of 250000340002 (column D) and in internal of
4500 (column L) in this case the summ =0 insert in AA of all 2 sheets
"BALANCED"...
Ecc...
here the file:http://www.mytempdir.com/1225837