copying infos

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.

Hi Tinbendr,

Please see above provided code, I see you copied same code. Please check. As per attached file, first row for Andrew should be 5461.23 and second row should be 635.13 in "cashbook" sheet(please be informed that amounts were taken from sheet "Registration" which highlighted yellow for example). But you see macros put 635.13 for first and second row.

Please help.

Many Thanks

Macros should check for duplication within each invoice. In cashbook sheet It should be shown both entries as 5,461 the first row and then second row should be the 635 value. Please play macros and you will see macros put 635 value each row.

Many Thanks, but please see attached spreadsheet which I added new column same as "Andrew". But still copying only 5461.23 and 635.13. But there are additional names like "Balandzic" as I higlighted. Could you please check.1008200 Copy info.xlsm

Many Thanks Tinbendr for explanation. It should be matches Cashbook!C:C to Registration!F:F, and Cashbook!S:S to Registration!H:H, and if there is a match, it puts from Regitration!K to Cashbook!X. And it puts from registration!C to Cashbook!V. Balandzic should be copied as there is no need to match values. Just if F+H(in Registration) matches C+S(in Cashbook), then put from Registration!C to Cashbook!V and put Registration!K to Cashbook!X.

Hope this time everything is clear.

Your help will be greatly appreciated.

There is no need to matching cost. Just please see on below:

If Registration!F+H matches Cashbook!C+S, then copy appropriate amount with the same line. For exmple, as you see in spreadsheet F7+H7(in registration) = C7+S7(in cashbook), then K7(in registration) copied to X9(in cashbook) same row as appropriate name.

As you see code was written for below request. But I have one problem that macros matches only last rows of equalization and put cast from Registration sheet to Cashbook sheet. As you see there are 3 rows which highlighted yellow with same name Balandzic. Macros should be took each cost to appropriate rows in cashbook. For example, Registration!F20+H20 = Cashbook!C13+S13, then amount from registration 42 should be copied to Cashbook!X13.

Hope you understand me and will help.