comapring two worksheets

D

dh

depends what your need to do, if looking for "math"
changes its' one thing, if your sheet has different number
of rows and columns then that's much larger.

if you have 2 sheets exactly the same, you can have a 3rd
sheet do a comparison of the cells on third sheet a1 of
sheet 1 minus a1 of sheet 2 will tell you if the math
results in a different value. Before you copy the A1
formula to the rest of teh sheet, use condtional
formatting to highlight the background if the value is not
zero, then copy the formual for the rest of relevant range.

it's not elegant but as a crude measure looking for math
only differences it works.

dave
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top