How similar is similar. Are the Customers exactly the same and located in
the same row on each sheet. Are the column headers exactly the same?

--
Regards,
Tom Ogilvy

"sifar" wrote in message
oups.com...
Hi,

if i have 2 similar reports in 2 different Excel sheets, & i want to
compare both the reports to see if the values in each column are the
same in both the report. IF not same, copy the values column header on
a separate sheet, along with the value & show the difference between
the 2 values.

for e.g.

1 report(Sheet1)
--------

Customer Name Credits Ratings
-------------------------------------
Al Capone 560 2
John Travolta 600 1
Johnny Depp 710 1


2 report(Sheet2)
--------

Customer Name Credits Ratings
-------------------------------------
Al Capone 560 2
John Travolta 600 1
Johnny Depp 601 4


Difference in 3rd Sheet(Sheet1 minus Sheet2)
--------------------------------------------

Customer Name InitialCredits FinalCredits CreditDiff
InitialRatings FinalRatings RatingsDiff
----------------------------------------------------------------------
Johnny Depp 710 601 109 1
4 -3


Please remember that i want to compare a lot of columns like these &
get their values, column headings & their difference in a 3rd sheet.