Hello Sir,
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 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(column X row 10) which it should be copied 635.13 amount.
Could you please help me to solve this?
Please Login or Register to view this content.
Bookmarks