Dear experts
I have data which was copied from pivot table with sum of total minus plus net to zero
report consistent start from A to G i want run vba into column E:E values greate than zero which are meet minus/plus net to zero where copy to crm raw
for e.g i want copy combination to corresponding header mismatch section in sheet crmraw like
0001-150702-959-XM000-0000-EUR find mismatch between minus and plus combination
start from code 6 digit 150702 is CRM Code into col C:C where mismatch,3 digit PA col D:D ,5 Digit bar code E:E,4 digit ICO code F:F, 3 digit currency code
G:G mismatch
0001-150702-959-XM000-0000-EUR value minus (4,817,332.08)
0001-480001-959-XM000-0000-EUR value is plus 4,817,332.08
mismatch combination is CRM Code 150702 & 480001
atlast if combination crm code & bar code 291201&00000 copy all values under header of 291201&00000 in column H:H
find the attachment!!
Bookmarks