Autopopulate data with duplicates from one sheet to another with only 1 instance

[bossbroccoli811]

Morning,

I have a small database that I am having to manual enter into way more than I should have to. I need PO numbers to autopopulate into a blank cell in the database when they are added to a different sheet from a receiving report pulled from Aurora (the cloud based system my company uses). The information is in duplicate on the receiving report, so I only need the first instance of the PO number to carry over.

I have been copy and pasting manually and it just takes way too much time.

Thanks.