Hello Sir,
I looked at the code and could not find a solution based on the current macro setup. In my opinion, its missing an extra loop that should check for duplication within each invoice. Without this extra loop, it is writing the data for Brill, Andrew with both entries as 5,461 the first time and then overwrites then with the 635 value. I tried to place the second loop in there, but couldn't.
Please see attached excel file which containing Registration sheet and Cashbook sheet. As you see in Cashbook sheet(column X) excel took 5461.23 amount from Registration sheet(which yellow highlighted) and copied to Cashbook sheet(column X row 9). And also copied this amount next below below(column X row 10) which it should be copied 635.13 amount.
Could you please help me to solve this? You can see macros from attached file.
Regards
Halidflight ucun exampleeee.xlsm
Bookmarks