Lukket

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.

Evner: Excel, Databehandling, C# Programmering, Dataindførsel, SQL

Se mere: 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

Om arbejdsgiveren:
( 0 bedømmelser ) New York, United States

Projekt ID: #27512952

54 freelancere byder i gennemsnit $367 på dette job

schoudhary1553

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 Flere

$500 USD in 10 dage
(410 bedømmelser)
8.2
(316 bedømmelser)
8.1
sumon355

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 dage
(309 bedømmelser)
7.7
(281 bedømmelser)
7.7
(354 bedømmelser)
7.7
mateenbhatti94

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 dage
(109 bedømmelser)
6.7
wsh2

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 Flere

$489 USD in 7 dage
(41 bedømmelser)
6.2
narsim3128

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 Flere

$250 USD in 2 dage
(67 bedømmelser)
6.0
AnowarRatul

----------------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 Flere

$250 USD in 2 dage
(195 bedømmelser)
6.0
(18 bedømmelser)
5.7
liveexperts123

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 Flere

$750 USD in 3 dage
(11 bedømmelser)
5.5
yehia111111

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 Flere

$278 USD in 7 dage
(10 bedømmelser)
5.1
nemanjadj20

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 Flere

$300 USD in 3 dage
(18 bedømmelser)
5.2
anandan1995

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 dage
(28 bedømmelser)
4.4
maguirrer

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 dage
(37 bedømmelser)
4.3
Vladius85

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 dage
(6 bedømmelser)
3.9
TEKSCENT

hi I have more than 10 years of professional experience in sql development and optimisation and worked in more than 300 projects in different database like Oracle,mysql/db2/ [login to view URL] discuss your requirements

$556 USD på 1 dag
(15 bedømmelser)
4.1
haleem0786

I can do this. I have good command over Ms excel especially pivot table, charts, advance formulas, formatting etc. Please inbox me for detail. Thanks Abdul Haleem

$250 USD på 1 dag
(28 bedømmelser)
4.2
MonisZafar

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 Flere

$250 USD på 1 dag
(20 bedømmelser)
4.5
tbrifki64

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 Flere

$350 USD in 5 dage
(15 bedømmelser)
4.3