Hi
I have data in two worksheets.
In worksheet1 column AF has a list of Purchase orders
In worksheet2 column B also has a list of Purchase orders
I would like to compare both worksheets and when a similar PO number is found, I would like the data in columns A and C in worksheet2 copied across to columns AD & AB in worksheet1, respectively
Sample attached
Sorry, I am only new to Excel, and I would greatly appreciate any help
I have data in two worksheets.
In worksheet1 column AF has a list of Purchase orders
In worksheet2 column B also has a list of Purchase orders
I would like to compare both worksheets and when a similar PO number is found, I would like the data in columns A and C in worksheet2 copied across to columns AD & AB in worksheet1, respectively
Sample attached
Sorry, I am only new to Excel, and I would greatly appreciate any help
