Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare two worksheets with "contains" and not "exact" values | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Lost "File Menu" - now it's "Edit / View / Insert.." but no "F | Excel Discussion (Misc queries) | |||
Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) | |||
Adding "New" "Insert" "Delete" into a workbook to change from data 1 to data 2 etc | Excel Programming |