Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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?
    Best Regards,

    Luke

  2. #2
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Hello - If both spreadsheets have the same "property" addresses, Sort both sheets by property address, then Copy and Paste the Columns from one sheet to the other. If necessary, CONCATENATE the addresses for the purpose of Sorting.


    Tim

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    352
    Thanks
    0
    Thanked 1 Time in 1 Post
    Unless the property lists are identical I would probably use vlookup formulas to copy the info across, then copy and paste-values to lock it in.
    David Grugeon
    Brisbane Australia

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •