Validation in Excel Sheets

[anandrajagopal]

Hi Team,

I need to do the following checking in excel Sheets.

We will be getting multiple excel file having unique sheet name for each excel file. namely,

1. Compared Result
2. Teradata Result
3. DB2 result

1. Need to compare and check Teradata Result and DB2 result sheets are sorted if not sorted then need to sort
2. Need to compare and check Teradata Result and DB2 result sheets columns are sorted if not need to sort the columnwise
3. Need to compare and check Teradata Result and DB2 result sheets values are sorted if not need to sort the values (ascending to descending)
4. Need to compare and check Teradata Result and DB2 result sheets row count are matches if not plz log in separate text file which row is missing
5. Need to compare and check Teradata Result and DB2 result sheets which columns are missing and log in separate text file
6. In Compared Result sheet, we have column headers in A1 Row (first row) and in A2 Rows we have TRUE OR FALSE values in each cell. If FALSE value is present in particular cell i need to compare this corresponding cell values( say example A2:C10) in TeraData Result and DB2 result sheet and find the difference value. This is applicable only to Integer Value in cell and not Strings in cells

Please provide some code in macros

Thanks
Anand R

[davesexcel]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic