Hello, I have two spreadsheets, one has parcel number and property address and name of property owner. The other has parcel number and mailing address of property owner. I need to merge the two spreadsheets together matching the property numbers and aligning the mailing address with the other information from the other spreadsheet. The problem is there are more parcel numbers on one sheet than the other so if I sort and copy they don't match up. There are over 5000 records so it is time consuming to hand sort and match. Anyone have any ideas.
Thanks!
Thanks!