I gang

VBA Scripts - Data Validation

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

Evner: Visual Basic

Se mere: vba data validation, vba scripts, vba validation, validation vba, vba work, what is vba in excel, what is vba, vba for, vba error, in vba, check data, vba, vba excel, VBA and excel, validation, validate excel, relationships\, project on vba, extract tables, excel to vba

Om arbejdsgiveren:
( 10 bedømmelser ) Fort Collins, United States

Projekt ID: #189385

Tildelt til:


As discussed: Use VBA code integrated to DAO will make the process in a few second instead of using traditional compare.

$200 USD in 2 dage
(11 bedømmelser)

2 freelancere byder i gennemsnit $160 på dette job


Hi, Expert here, lets start!

$120 USD in 2 dage
(3 bedømmelser)