Automation Assistance

Occasional Visitor

Good afternoon all


I am simply trying to make my life easier when generating POs and then inputting data. 

A PO is generated from a worksheet (1) and on worksheet 2, extra data is entered. 


I am hoping there is a way to copy the date in a row across to automatically fill when the corresponding PO is entered (see highlighted yellow). NB - There may be multiple lines with the same PO according to items ordered. 

I have simplified the spreadsheets to try and show this. 

1 Reply


I've used VLOOKUP in the attached. There are other ways to accomplish a lookup, retrieving data from one table  to bring it into another. VLOOKUP is the oldest and one of the most popular of all Excel functions.  Let us know if this is the solution you're looking for.