+ Reply to Thread
Results 1 to 3 of 3

Comparing data between worksheets

Hybrid View

  1. #1
    Registered User
    Join Date
    12-12-2008
    Location
    London
    Posts
    28

    Comparing data between worksheets

    I wonder if any one can assist me in what is probably an easy problem.

    I have two worksheets, whereby the headers pm each worksheet are the same. the data however may not be. If the entries are different, I have used =IF(ISNA(VLOOKUP(B2,'Master 0202'!B2:B50,1,FALSE)),"New","") to pick up new entries. Fine.

    However, those that are not new, i.e. they are both in the old worksheet and the new worksheet, I need to find out whether there is any change in any of the cells. The headers run from columns A to W.

    How can I find out if there are any changes in any of the cells in one go? Can I use another VLOOKUP?

    Thanks in advance

  2. #2
    Forum Expert Kevin UK's Avatar
    Join Date
    12-07-2010
    Location
    Radstock, Somerset
    MS-Off Ver
    365
    Posts
    1,922

    Re: Comparing data between worksheets

    Hi m5rcc

    One way would be, on a new sheet for example:
    Formula: copy to clipboard
    =IF(Sheet1!A1=Sheet2!A1,"","Change")


    Copy across and down as far as required.
    Regards Kevin


    Merged Cells (They are the work of the devil!!!)

  3. #3
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Comparing data between worksheets

    Cross posted at Ozgrid
    Palmetto

    Do you know . . . ?

    You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.

+ 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