![]() |
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