Results 1 to 6 of 6

Comparing 2 lists

Threaded View

tsrwebman Comparing 2 lists 02-17-2012, 08:29 AM
dilipandey Re: Comparing 2 lists 02-17-2012, 08:38 AM
Fotis1991 Re: Comparing 2 lists 02-17-2012, 08:38 AM
tsrwebman Re: Comparing 2 lists 02-17-2012, 09:20 AM
tsrwebman Re: Comparing 2 lists 02-17-2012, 09:24 AM
tsrwebman Re: Comparing 2 lists 02-17-2012, 09:39 AM
  1. #5
    Registered User
    Join Date
    05-10-2010
    Location
    Telford, England
    MS-Off Ver
    Excel 2003
    Posts
    33

    Re: Comparing 2 lists

    no - thats not quite correct - it would copy all the rows
    try this

    for each row in sheet2
    for each row in sheet 1
    if (Sheet2: thisrow:cells1-7 exactly matches Sheet1:this row: cols 1:7)
    mark as found and exit loop
    else
    mark as not found
    end if
    next row sheet 1
    if not found copy sheeet2:thisrow to sheet3
    next row sheet2
    Last edited by tsrwebman; 02-17-2012 at 09:26 AM.

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