Käynnissä

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

Taidot: Visual Basic

Näytä lisää: 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, data validation, Data tables, data log, counting, project database vba excel

Tietoa työnantajasta:
( 10 arvostelua ) Fort Collins, United States

Projektin tunnus: #189385

Myönnetty käyttäjälle:

riyoyo

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

200 $ USD 2 päivässä
(11 arvostelua)
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 Lisää

289.95 $ USD 3 päivässä
(16 arvostelua)
5.0
asaikiran1979

Hi, Expert here, lets start!

120 $ USD 2 päivässä
(4 arvostelua)
2.6