Hi

I am trying to create a validation excel sheet for the business users to make sure they are at least keying data in the sales sheet required fields also check for duplicates in the sales sheet.

My sales spreadsheet looks something like this.

Transaction Id, Transaction Amount, Transaction Date, Account, Account Type etc

The basic idea for this validation spreadsheet is to validate data in the Sales spreadsheet as this is manually edited by sales team. They sometimes forget to save their changes or key nothing and have many blank cells, which in turn screws the ETL load to the database throwing errors. For instance "Sales" table cannot have NULL value in the column "Account".

My question is how do I develop this validation spreadsheet which validates against sales spreadsheet.

Thanks