Compare Sheets and find missing Columns

[anandrajagopal]

Hi Team,

I need to compare two sheets on same workbook and find missing columns on which sheet. And if columns are missing then i need to write the log in text files along with the date

Please advice how to do it?

Thanks
Anand R

[anandrajagopal]

Hi Team,

PFA my sample document. Here,

1. I need to compare TD sheet with DB2 sheet and check whether we have the same columns and count. if there is any columns mismatch in any sheet then we need to log into text file saying that so and so columns are missing in TD or DB2 sheet
2. Need to compare TD sheet with DB2 and make sure we have the same order of columns present in TD Sheet, if not then need to sort it according to DB2 sheet.

Thanks
Anand R

[anandrajagopal]

Hi TEam,

Any luck?

Regards
Anand R