I attached two file there is same VBA code in both files but that VBA code work in first file & not working in second file
you can see in first file in cell N13 & cell N49 there is same number which is 2419 whenever this happen it means when same
number occur VBA code do the sum of both values of cell Z13 (value of Z13 1078839) & Z49 (value of Z13 60607), sum of both values is 1139447
put that sum in first cell (here is cell Z13) & put zero in another cell VBA code do that sum for every same number
but that VBA code not work in second file
Bookmarks