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.

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.

Hi Tom,

Both the reports are similar. one report data is entered by a Workflow
dept & the other is done by operations. but the formats are the same.
What i am trying to do is to tally both the datas in the reports so that
they should be same. if they are not same, have to inform workflow dept
of the difference & based on the difference workflow should make payment
for the difference.


Warm Regards,

Eijaz


*** Sent via Developersdex http://www.developersdex.com ***