Results 1 to 15 of 15

comparison macro

Threaded View

  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