Show the row which updated last time in a different sheet

Metalizator

New Member
Joined
Jul 27, 2021
Messages
1
Office Version
  1. 2019
Platform
  1. 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
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Show the row which updated last time in a different sheet
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.
 
Upvote 0

Forum statistics

Threads
1,213,551
Messages
6,114,266
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top