I need some validation work done via Excel VBA
Another development team is creating a database that has approx. 20 tables. These tables will not have a relationship within that database. There will be an extra table called relationship that will display the relationships of the tables (for example: Table1 is called Project and Table 2 is called Products. In the relationship table there will be a field for the project name (from table 1) and then all related products for that project)
It will be my job to extract all those tables to spreadsheets to validate them. Some of the validation that I will is as followed:
1. Check for duplicates names in only certain spreadsheets – For example column B in approx 5 spreadsheets need to be validated to make sure they are unique for a certain ID in column A. (PLEASE REVIEW EXAMPLE IN ATTACHMENT) If any are found they the duplicates rows (not counting the first) will need to be removed to an error log spreadsheet and placed in a worksheet based on what table it came out of.
2. Check to make sure that each product (table 2) has a project (table 1) using the relationship table that I mentioned above
a. If any errors are found then they are copied to the error log spreadsheet and stored in a worksheet called: No_Parent