Kapalı

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.

Beceriler: Excel, Veri İşleme, C# Programlama, Veri Girişi, SQL

Daha fazlasını gör: 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

İşveren Hakkında:
( 0 değerlendirme ) New York, United States

Proje NO: #27512952

Bu iş için 53 freelancer ortalamada $369 teklif veriyor

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 Daha Fazla

$500 USD in 10 gün içinde
(417 Değerlendirme)
8.2
(318 Değerlendirme)
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 gün içinde
(315 Değerlendirme)
7.7
(298 Değerlendirme)
7.8
(354 Değerlendirme)
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 gün içinde
(113 Değerlendirme)
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 Daha Fazla

$489 USD in 7 gün içinde
(41 Değerlendirme)
6.2
(20 Değerlendirme)
5.8
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 Daha Fazla

$250 USD in 2 gün içinde
(68 Değerlendirme)
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 Daha Fazla

$250 USD in 2 gün içinde
(203 Değerlendirme)
6.1
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 Daha Fazla

$750 USD in 3 gün içinde
(12 Değerlendirme)
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 Daha Fazla

$278 USD in 7 gün içinde
(10 Değerlendirme)
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 Daha Fazla

$300 USD in 3 gün içinde
(21 Değerlendirme)
5.3
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 gün içinde
(32 Değerlendirme)
4.6
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 gün içinde
(37 Değerlendirme)
4.3
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(22 Değerlendirme)
4.5
Darwish001

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 Daha Fazla

$300 USD in 7 gün içinde
(1 Yorum)
4.0
anpilogovfree

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 gün içinde
(5 Değerlendirme)
4.0
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 Daha Fazla

$350 USD in 5 gün içinde
(15 Değerlendirme)
4.4
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 gün içinde
(6 Değerlendirme)
4.0