Complete a database with missing data

Needs to hire 2 Freelancers

I have a set of data.

Column A has some values (Parent ID's) for a company (values in column C)

For each Parent ID I have a set of children, which must be added to the table.

In Column G for each children, I need the parent ID and in C I need the company # of the parent ID.

Then for a certain Special Parent ID I need to replace the value in Column G for a fixed value.

And for each of these special parent ID's in the database, I need a new row with a fixed set of values.

This can be achieved in 3 steps with Formulas such as VLOOKUP... or ideally with a macro which I can reuse. I can provide you the data columns in Sheet 1, where the macro gets the data from to create the database in sheet 2.

Habilidades: Excel, Processamento de dados, Programação C#, Processamento de Dados, SQL

Veja mais: sql find missing values in a sequence, sql find missing values in a range, sql find missing values from list, sql query to find missing records, how to find missing records in a table in sql, how to find missing values in sql, which keyword is used to sort the data in sql, sql select rows with missing values, complete database project hospital management system sql, role database developers data mining, access database web data capture, create database normalize data, sql database missing, netbeans database export data, oscommerce database missing products, find information complete various entries data fields spreadsheet, database online data feeds rss, complete database countries states, csv complete database using php, data cleansing steps excel

Acerca do Empregador:
( 0 comentários ) New York, United States

ID do Projeto: #27512952

53 freelancers estão ofertando em média $369 nesse trabalho


Hi, Greetings! ✅checked your project details: Complete a database with missing data ✅Completed Time: In project deadline We have worked on 650 + Projects. I have 6 + years of the experience in same kind of proje Mais

$500 USD in 10 dias
(417 Comentários)
(318 Comentários)

Hello, As an experienced VBA developer, i am very much interested to create the required excel macro to do this task. Please send me the example file. Thanks

$300 USD in 4 dias
(315 Comentários)
(298 Comentários)
(354 Comentários)

Hi I will build you a macro which you can reuse.I will provide your instructions. would you like to discuss the project with me?

$250 USD in 2 dias
(113 Comentários)

At your earliest convenience, please attach any data/report workbook sample(s) you may have to this private chat message thread so we may better analyze and discuss your requirement. Many thanks in advance! Greetings Mais

$489 USD in 7 dias
(41 Comentários)
(20 Comentários)

NOTE : I HAVE EXPERTISE IN EXCEL AND VBA. I CAN COMPLETE THIS TASK IN QUICK TIME. With respect to this project I would like to present myself as a candidate for your consideration. I have more than 12 years of IT expe Mais

$250 USD in 2 dias
(68 Comentários)

----------------EXCEL EXPERT-----START RIGHT AWAY --------------------------------- Hello sir, I can do this as your requirements by maintaining 100% accuracy of your data absolutely as you want. ------- VBA Macro Codi Mais

$250 USD in 2 dias
(203 Comentários)

Hi there, I have read your project description and i'm confident i can do this project for you perfectly.I still have a few questions. please leave a message on my chat so we can discuss the budget and deadline of the Mais

$750 USD in 3 dias
(12 Comentários)

Hi There, I am Technical Consultant with 12+ years experience of C# desktop applications, SharePoint and .NET Web Applications both Web forms and MVC, WCF and Rest API. It's 10 years away from freelance i just come bac Mais

$278 USD in 7 dias
(10 Comentários)

Hello? I have worked on Excel/Word/PPT/MACRO projects to what you are looking for, and I am confident I can exceed your expectations. I have attached samples of work very similar to what you are seeking. # create Mais

$300 USD in 3 dias
(21 Comentários)

I have a experience in asp.net, MVC, web API, c#, SQL, entity framework,linq, razor view (Cshtl), html, bootstrap,Angular JS, Jquery, Json,XML, reports (PDF,xls, crystal, rdlc,ssrs).

$250 USD in 5 dias
(32 Comentários)

Hello, I can help you with the macro to complete the missing columns of the database, but please send me a message with more details and I can start working on it inmediately

$250 USD in 5 dias
(37 Comentários)

Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this through a VBA script. It will be quick and accurate. I will start immediately and complete it within a few hours. I Mais

$250 USD em 1 dia
(22 Comentários)

I CAN COMPLETE YOUR PROJECT EASILY Hello, I am software developer with enough experiences on C#/.NET for 13 years. I can work by full time for your project and trying to satisfy the requirements. I am designing the pro Mais

$300 USD in 7 dias
(1 Comentário)

Hello! As data analytics expert, I can complete your project successfully. Well familiar with the database systems, I can fill your data from other fields of the database. Best regards.

$500 USD in 5 dias
(5 Comentários)

I am sure I can help you. I used to code in dBase III or Clipper 5. Currently, I code in SQL, Visual Basic, Visual Basic For Application (VBA) C#, and R. Full-blown up software I have developed: NATO Codification Syst Mais

$350 USD in 5 dias
(15 Comentários)

Hi, I can make macro or desktop application to complete a database with missing data. Can you provide some data as a sample?

$250 USD in 3 dias
(6 Comentários)