+ Reply to Thread
Results 1 to 2 of 2

How to match rows in 2 sheets and update them

  1. #1
    Registered User
    Join Date
    02-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2003, Excel 2007
    Posts
    54

    How to match rows in 2 sheets and update them

    I am attaching my excel spreadsheet with this post:

    In sheet1: I have these records: (Company Records)
    In sheet 2: I have these records: (All Records)
    In sheet 2 i have all the contacts that includes personal contacts, company contacts etc plus in few records there is no company name, address etc

    (a)Now in sheet 3 i want those records (with complete row i.e. all fields) from sheet 2 that matches with records in sheet 1 (matching will be based on First Name, Last Name & CompanyName)
    (b) In addition to that the records which are in sheet 2, i am not sure if they are correct or not,
    so if any row (from sheet 2) matches with row(in sheet 1)[on bases of 3 fields that i mentioned above] i want Address, website and JobTitle (in resultant sheet 3) to be updated according to sheet 1
    How to do that ? please guide me....as i have 10,000 records and manually doing each one is not possible....

    i have mentioned my problem/issue on the excel sheet also...

    I would really appreciate if anyone could help me with this....
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    02-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2003, Excel 2007
    Posts
    54

    Re: How to match rows in 2 sheets and update them

    anyone ? Please...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1