Show the row which updated last time in a different sheet

[Metalizator]

Hi all.
I attached the file I have problem with. All codes/formulas I have in there I found from here and there, but I can't find solution for this one, so I surrendered.
First you must try how my excel file works and what I do with it. So, please open it.
I use it for checking delivered goods if they're correct due to invoice.
If you enter sample barcodes shown in "Barcode" column of the "Received" sheet to "Single entry" in "ScanIn" sheet it will add 1 to "Proved quantity" column in "Received" sheet (or if you first add, let's say, 5 to "Multiple entry" column in "ScanIn" sheet and then enter barcode to "Single entry" it will add 5 to "Proved quantity") Now, all I want is to display that row which LAST TIME updated by adding quantities to that ("Proved quantity") cell in "ScanIn" sheet (you can see place for it). I mean, every time different rows of "Proven quantity" updates, it would show the last one.

Thanks in advance.

[kvsrinivasamurthy]

Which column is having "Proven Quantity".

[Metalizator]

It's in the "Received" sheet. It's Proved*. I fixed the typos.

[kvsrinivasamurthy]

Worksheet event is used.

Please Login or Register  to view this content.

[Metalizator]

No, it doesn't work and it's totally ruined. I see you replaced main code from the module with yours.

[kvsrinivasamurthy]

If it is not ok. Leave it and go ahead.