how can I compare spread sheets?

  • Thread starter Thread starter wmw
  • Start date Start date
W

wmw

Dear All,

How can I compare two data sets on two work sheets, in a way lik
"compare and merge documents" function in Microsoft Word.

I want to do it in a way that merge the two and get the different cell
highlited without making duplication.

NB: I cannot use VBA macros on my computer at work :mad:

Thanx a millio
 
Hi

not allowed to use macros!!!! eek!

hoping the two worksheets aren't huge
if you create a third worksheet and in cell A1 of this worksheet put
=IF(Sheet1!A1=Sheet2!A1,"",Sheet1!A1 & " : " & Sheet2!A1)
then fill down & across your data area
.... then when the two sheets aren't equal the differences will be displayed
in this worksheet.

Hope this helps
Cheers
JulieD
 
Back
Top