Metalizator
New Member
- Joined
- Jul 27, 2021
- Messages
- 1
- Office Version
- 2019
- Platform
- Windows
Hi all.
I attached the link to 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 "Proven quantity") Now, all I want is to display that row which LAST TIME updated by adding quantities to that ("Proven 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.
Link to file
I attached the link to 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 "Proven quantity") Now, all I want is to display that row which LAST TIME updated by adding quantities to that ("Proven 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.
Link to file