Compare Sheets and find missing Rows

[anandrajagopal]

Hi Team,

I need to compare two sheets on same workbook and find missing rows on which sheet and need to write in log (example : text file).

Please advice how to do it?

Thanks
Anand R

[anandrajagopal]

Sorry to add one info..


if row count is not matches in any of the sheet then i need to write a log in text file on which sheet the rows are missing

Please advice how to do it?

Thanks
Anand R

[anandrajagopal]

hi team,

Any luck?

Thanks
Anand R

[anandrajagopal]

Hi Team,

I have attached the excel document in this reply.

Thanks
Anand R

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[anandrajagopal]

Hi,

Thanks for you code.. it is working fine...

But my requirement is that i need to get the missed rows and log into text files and saying that DB2 or Teradata rows are missing.

Thanks
Anand R

[JOHN H. DAVIS]

Sorry I'm a little confused. Can you post a sample of what your Compare sheet should actually look like when the macro is run? Or am I still not getting it?

[anandrajagopal]

Hi John

PFA my sample document. In our scenerio, we have dynamic columns in each workbook and not specified to fixed number of columns. So we need dynamic used range columns to validate.

[JOHN H. DAVIS]

If sheets DB2 and TD will always have the same amount of columns then maybe this will work for you?

Please Login or Register  to view this content.

[anandrajagopal]

Hi John,

BTW, how to log missing rows in text file for the above scenario?

as per my understandings for the above code, you are comparing the 2 sheets TD and DB2 with value and assigning the value to compared sheet. But my requirement is that i need to get the missed rows and log into text files and saying that DB2 or Teradata rows are missing.

Can you help on this?

Thanks
Anand R