I have order information in two different spreadsheets ("Sale" & "Ship To") Both have a field/Column "Customer #" I want to compare the customer numbers between the two sheets and when there is a match transfer the data from Sheet 2 "ShipTo" to blank columns in the Sheet 1 "Sale."
I've attached an example workbook I put together.
Thanks so much in advance!
Bookmarks