PDA

View Full Version : [SOLVED] VBA to compare multiple worksheets and produce report of cells where data varies



plasteredric
11-22-2017, 01:54 PM
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

paulked
11-23-2017, 11:49 AM
21034

Cheers

Paul Ked

plasteredric
11-23-2017, 03:55 PM
21034

Cheers

Paul Ked

Cheers Paul, works great

paulked
11-25-2017, 03:34 AM
Please mark as Solved :)