ms office - Search and copy information from an Excel sheet to another based on existing data

Question

I have the following scenario: I have 2 files: NO1 and NO2. The File NO1 is produced by a software every time I need one but the lines are not in the same order since new information is uploaded into the software. Instead of applying all the time Vlookup and search for the updates. I would like to have the file NO2 which searches automatically in file NO1 based on column no1 values( they also change every time I open the document). and copy the last update infor(other columns) to the file NO02. As an example bellow: See this example

If you see the number is the same but has a different status based on date. I would like the line with the last status update to be copied to file NO2. Would be amazing if every time I open the file NO2 it will update from the file N01 with the latest status updates. I have a rough idea that I need to use VLOOKup in the second file to search in the first file but I do not know how to do it. Also keep in mind that due to security I am not allow to install any kind of additional software/plugin on my working computer, it has to be done through Excel only. Thank you for considering helping me.

Answer 1

等待大神答复