ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Compare aumont and insert "Balanced"... (https://www.excelbanter.com/excel-programming/384066-compare-aumont-insert-balanced.html)

sal21

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



All times are GMT +1. The time now is 06:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com