Complete a database with missing data

ปิด โพสต์แล้ว 3 ปีที่ผ่านมา ชำระเงินเมื่อจัดส่ง
ปิด ชำระเงินเมื่อจัดส่ง

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.

Excel การประมวลผลข้อมูล การเขียนโปรแกรม C# คีย์ข้อมูล SQL

หมายเลขโปรเจค: #27512952

เกี่ยวกับโปรเจกต์

50 ข้อเสนอ โปรเจกต์ระยะไกล ใช้งาน %project.latestActivity_relativeTime|แทนที่%

freelancer 50 คน กำลังเสนอราคาในงานนี้ โดยมีราคาเฉลี่ยอยู่ที่ $374

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 เพิ่มเติม

$500 USD ใน 10 วัน
(443 รีวิว)
8.4
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 ใน 4 วัน
(331 รีวิว)
7.8
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 ใน 2 วัน
(122 รีวิว)
6.9
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 เพิ่มเติม

$250 USD ใน 2 วัน
(281 รีวิว)
6.4
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 เพิ่มเติม

$750 USD ใน 3 วัน
(13 รีวิว)
6.0
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 เพิ่มเติม

$250 USD ใน 2 วัน
(75 รีวิว)
6.1
EkoLike

Hello. in desktop application, i am very excellent. java, c++, c#, vba, python etc. and also i am good at algorithm project just DFS, BFS, A*, Uniform, Greedy Algorightm before I was in many desktop app such as c++, เพิ่มเติม

$250 USD ใน 2 วัน
(16 รีวิว)
5.1
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 เพิ่มเติม

$278 USD ใน 7 วัน
(11 รีวิว)
5.3
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 เพิ่มเติม

$300 USD ใน 7 วัน
(2 รีวิว)
4.9
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 ใน 5 วัน
(33 รีวิว)
4.8
hayteekeys

Hi, I'm a professional and expert in Data works or projects..My skills and services include: - Web scraping - Data entry - Data mining - Data processing - Excel - MySQL - Oracle -Financial Analysis -Advanced Excel -MS เพิ่มเติม

$250 USD ใน 2 วัน
(15 รีวิว)
4.6
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 ใน 5 วัน
(7 รีวิว)
4.7
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 ใน 3 วัน
(6 รีวิว)
4.4
mkh559a5a1fd66e9

hi, I am well versed in c# programming, SQL, Data Processing, Data Entry, Excel I will do your query task in short time. to procreed on it feel free to meet me in chatbox.

$250 USD ใน 1 วัน
(17 รีวิว)
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 เพิ่มเติม

$350 USD ใน 5 วัน
(15 รีวิว)
4.6
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 ใน 1 วัน
(30 รีวิว)
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 เพิ่มเติม

$250 USD ใน 1 วัน
(25 รีวิว)
4.7
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 ใน 5 วัน
(39 รีวิว)
4.4
kapilasl

Hello, I am full stack developer. I can handle your requirement successfully. Please contact me via chat and share your sample data file and more details for me Thank you, Kapila

$560 USD ใน 7 วัน
(12 รีวิว)
4.1
aap31374

I have more than 15 years of experience in SQL Server database design, modelling, development and Administration. I have worked for database designing and modelling of complex business requirements at efficient way. เพิ่มเติม

$556 USD ใน 2 วัน
(5 รีวิว)
3.4