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. #1
    Registered User
    Join Date
    05-10-2010
    Location
    Telford, England
    MS-Off Ver
    Excel 2003
    Posts
    33

    Comparing 2 lists

    I have a spreadsheet with 2 sheets.
    Sheet 1 - 7 columns, abt 4000 rows
    Sheet 2 - 7 columns, abt 2000 rows.

    7 columns are the same content and format on each sheet.

    I want to create Sheet 3 - again 7 columns
    It must contain ONLY those rows that are in Sheet 2 and not in sheet 1
    I dont think there will be many

    Any any ideas how to go abt this easily - its a one ooff job so doesnt need to be particulary 'user friendly'

    I use office 2007 and am happy working with macros

    I have no idea how to start and would appreciate help

    Thanks
    Last edited by tsrwebman; 02-17-2012 at 08:32 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