Consulting

Results 1 to 4 of 4

Thread: VBA to compare multiple worksheets and produce report of cells where data varies

  1. #1

    VBA to compare multiple worksheets and produce report of cells where data varies

    I'd like to be able to compare two (possibly three further down the line) ranges from different sheets to find where the data is different. i.e. does sheetA!A4 match sheetB!A4 ... sheetA!A5 match sheetB!A5 etc etc. then compile a list in SheetC with the cell references and contents for those cells that dont match.

    Would this be possible?
    cheers

  2. #2
    VBAX Master paulked's Avatar
    Joined
    Apr 2006
    Posts
    1,007
    Location

    Something like this?

    Check.xlsm

    Cheers

    Paul Ked
    Semper in excretia sumus; solum profundum variat.

  3. #3
    Quote Originally Posted by paulked View Post
    Check.xlsm

    Cheers

    Paul Ked
    Cheers Paul, works great

  4. #4
    VBAX Master paulked's Avatar
    Joined
    Apr 2006
    Posts
    1,007
    Location
    Please mark as Solved
    Semper in excretia sumus; solum profundum variat.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •