Hi SamT

Thanks a lot for reading my long post...
I think at this point the best is too give you a bit of background...

We have a System from where we drop orders.
My team must upload/input in this system prices, freights, import duties for all the part numbers (products), on this purpose we use a mass upload tool created years ago by our IT team.
Prices, Freights, Import Duties are provided by another team.
They fill in a Request Form (that is actually what you have in sheet2) and ask us to upload those in the system according to their request.



using their request form I upload/transfer those info in our system, but we have an old issue with our mass upload tool and sometimes the upload can be NOT entirely successful, and for few part numbers either the price or the freight or only the currency of those can be wrongly uploaded.

So after the upload I MUST double check if everything is ok, hence I started to work on this tool.
I copy the request form in sheet2, then I download the info from the system (sheet1) and comparing those two sheets I check if the mass upload (transfer) of the info went through correctly.

So going back to our project for example :

  1. The request from the other team is: Vendor X Plant NL10 P/N Apple Price 4$ Freight 4€ import duties 3,5
  2. I transfer those INFO to the system via the mass upload tool (that unfortunately I cannot trust blindly).
  3. After the upload I download an extract from the system (what you have in sheet1) and I compare it to what I had in the request (what you have in sheet2) to see if the INFO upload went 100% through.
  4. Part numbers can be thousands that is why I need a tool to check all of them and fix them if needed.