In Progress

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

Skills: Visual Basic

See more: vba data validation, vba scripts, vba validation, validation vba, vba work, vba for, vba error, in vba, check data, vba excel, validation, validate excel, extract tables, data validation, data tables, data log, counting, project database vba excel, excel log database, excel database visual basic, display related products, log excel visual basic, excel vba validation project, excel based database vba, visual basic scripts

About the Employer:
( 10 reviews ) Fort Collins, United States

Project ID: #189385

Awarded to:

riyoyo

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 days
(11 Reviews)
5.6

3 freelancers are bidding on average $203 for this job

wsh2

This sounds like a Bill Of Material Processor. So lets make it fun.. How about one (parent) project consisting of one or more (child) sub-projects? Put in the parent project number and let it explode downwards through More

$289.95 USD in 3 days
(16 Reviews)
5.0
asaikiran1979

Hi, Expert here, lets start!

$120 USD in 2 days
(4 Reviews)
2.6