Compare aumont and insert "Balanced"...

S

sal21

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top