Hi,
I have two spreadsheets with the same information in for a couple of the columns about Property Information, but on the other sheet it has information about the owner (address details, etc).
For example, I have Information about the property address (broken down into four fields), the owner name (broken down into three fields) in one spreadsheet.
On the other spreadsheet I have the four fields for the property address, not the owners name, but then five fields of the owners correspondance address. I need to merge the information based upon the Address1 column.
I would like to be able to merge the two together?
Is this possible in Excel?
