Macro for comparison between two workbook specific sheet

[paradise2sr]

Dear Sir,

I have two workbooks (Ram & Shyam).I want to compare each & every cells these two workbooks of specific sheet only i.e say 'Data' sheet.If found any differences between these two, then differences of result of these two must be displayed in anyone sheet.

Is this possible by vba/macro or not ? If so, kindly help me in this regard.

With Best Rgds,

[JOHN H. DAVIS]

Does this help?

Please Login or Register  to view this content.

It highlights the data cells in Workbooks Ryam Sheets Data that does not match there counterparts in Workbook Shyam.

[paradise2sr]

I have a case of large data, and it will be difficult to find each and every highlighted cells.Is it possible to get summary report of differences/unmatched data.

I would be very much thankful in this regard

[JOHN H. DAVIS]

Try:

Please Login or Register  to view this content.

Created a Sheet Summary in Workbooks Ram.

[paradise2sr]

I am getting a run-time error 9,Subscript out of range in your suggested code.Kindly debug the error.

[paradise2sr]

I have attached files for your kind reference.I have made changes by highlighting in yellow in "Ram.xlsx".Kindly debug and resend back.I don't know why there is an error.

I will be eagerly waiting for your reply.

With Best Rgds,

[paradise2sr]

I have found in the below link >>>

http://superuser.com/questions/42627...-track-changes

somewhere there is a line "This code also creates a hidden Change Log sheet and records the address and original font color of the cell that has been changed."

Perhaps this might help with log file.But don't know how to modify the code for entire data of a single sheet.

Hope anyone can help me.

With Best Rgds

[JOHN H. DAVIS]

I am getting a run-time error 9,Subscript out of range in your suggested code.Kindly debug the error.

You're receiving an error because in the code you need too change .xls to .xlsx

[paradise2sr]

Dear Sir,

That things already I have done but there was error which I don't know.

[Fotis1991]

Looks that you need a Time Out of the forum as we warned you many times to read carefully the forum rules.

You preferd to ignore us and continue to don't comply with them.

You let me no choice...

John sorry for your effords.

[paradise2sr]

Dear All forum contributors,

I am extremely sorry that I have hurt to anyone nor my intention is to do.This might has been done unknowingly or in innocence.Since the above code if I cannot be able to executed properly and gets an error than what should I do ? The only option is to get help from the above contributors that supplied the code.I know the expected solution of vba code is simply to be pasted in module/sheet/workbook.This things I know.But what in case if I am incurring error ?

I have learnt a lot from this forum and would not like to be get banned/restricted from posting.Whenever I feel any real life problems in course of my work,I expect that I could get solved from this forum.

Hope,I will not get banned further and will not get infractions too.

With Rgds,

[paradise2sr]

I am now closing this thread.