Results 1 to 15 of 15

comparison macro

Threaded View

beatrice25 comparison macro 10-24-2008, 08:24 PM
mdbct I'm assuming by "cell-by-cell... 10-24-2008, 09:46 PM
mikerickson Perhaps this will do what you... 10-25-2008, 01:20 AM
beatrice25 works well but.... 10-27-2008, 05:11 PM
mdbct Using the non-conditional... 10-27-2008, 09:28 PM
beatrice25 Thanks mdbct 10-28-2008, 11:35 AM
mdbct From my first post ... 10-28-2008, 11:45 AM
beatrice25 fantastic..can this macro be... 10-28-2008, 01:34 PM
mdbct Please wrap the code in your... 10-28-2008, 01:57 PM
beatrice25 work well thanks 10-28-2008, 06:29 PM
mdbct You were close. You told the... 10-28-2008, 09:08 PM
beatrice25 now getting compile error 10-29-2008, 11:27 AM
mdbct It had to do with the... 10-29-2008, 11:36 AM
beatrice25 perfect....just perfect! 10-29-2008, 03:04 PM
beatrice25 my problem is resolved -... 10-29-2008, 03:14 PM
  1. #1
    Registered User
    Join Date
    05-16-2006
    Posts
    93

    comparison macro

    Hi All,
    Can anyone help me here please....
    I need to compare the values of data on one sheet (sheet1) with that of another (sheet2) to see if there has been any changes between the sheets over the previous week. If a macro could go through my data on sheet1, compare cell-by-cell the data that's in sheet 2 and highlight in red font any cells that have different values that would be awesome.
    The macro would need to leave the "fill color" of the cell as it was.

    Any help much appreciated

    Thanks

    Beatrice
    Last edited by VBA Noob; 10-29-2008 at 03:10 PM.

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