Results 1 to 4 of 4

Indicate different cells in two worksheets

Threaded View

  1. #1
    Registered User
    Join Date
    10-10-2011
    Location
    Maastricht, Netherlands
    MS-Off Ver
    Excel 2007
    Posts
    2

    Red face Indicate different cells in two worksheets

    Hi all,

    I've been struggling with this question for hours now.

    I have two worksheets in one workbook.
    An example of both can be found below.

    How can I create my desired outcome as described in the last part?


    Sheet 1 “offDB” : (contains the official database, total: 73.619 rows)

    ID Model Name Manufacturer
    100100 G410 Mitsubishi
    100200 A53 Siemens
    100300 TBD (AAB-1880030-BV) Sony Ericsson
    100400 RM-669 Nokia
    100500 M930 NA DB Motorola
    100600 EBX700 Panasonic
    100700 Tester Sony Electronics
    100800 TCD718 Philips
    etc.


    Sheet2 “ourDB” :
    (contains our own database, total: 41.470 rows)
    (please note that some rows that can be found in sheet1 are missing in this sheet.)

    ID Model Name Manufacturer
    100100 G410 Mitsubishi
    100200 A53 Siemans
    100400 TRM-669 Nokia
    100500 M930 NA DB Motorola
    100600
    100800 TCD718 Philips
    etc.


    Desired outcome:Sheet2:


    \1

    Any help is greatly appreciated!
    Last edited by MaxWol; 10-10-2011 at 07:04 AM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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