1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Comparing workbooks

Discussion in 'Business Applications' started by tinsel10, Jan 16, 2006.

Thread Status:
Not open for further replies.
Advertisement
  1. tinsel10

    tinsel10 Thread Starter

    Joined:
    Dec 13, 2004
    Messages:
    17
    Need to compare 2 similar workbooks where slight changes have been made to the second workbook. Would like Excel to highlight the changes so that they can then be corrected in the original workbook.

    Is there any way of doing this in Excel 2003?
     
  2. OBP

    OBP Temporarily Banned

    Joined:
    Mar 8, 2005
    Messages:
    19,889
    How many cells in how many ranges?
    It can be done in VBA but it may be a bit slow if you have vast amounts of data to check.
     
  3. Zack Barresse

    Zack Barresse

    Joined:
    Jul 25, 2004
    Messages:
    5,452
    Can you post a small sample of your workbook? Without more data, it's about like shooting in the dark..
     
  4. tinsel10

    tinsel10 Thread Starter

    Joined:
    Dec 13, 2004
    Messages:
    17
    I have found the Compare and Merge feature and I am currently testing whether that will do the job. Will get back to let you know. Thanks
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Similar Threads - Comparing workbooks
  1. estyMonsty
    Replies:
    7
    Views:
    308
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/434533

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice