已完成

Write an Excel Macro to transform data

The project is regarding transforming BOM (Bill of Material) data of multiple items in one sheet to separate sheets.

E.g. - A Fan is made from 3 Nos blades, 1 Nos motor and 10 Nos screws. 1 motor in turn is made from 3 m wires and 2 Nos plates. [Nos and m are Unit of measurement - Number and Metre respectively]

So our master excel sheet contains data as -

Fan | .1 | Blades | 3 | Nos

Fan | .1 | Motor | 1 | Nos

Fan | ..2 | Wires | 3 | m

Fan | ..2 | Plates | 2 | Nos

Fan | .1 | Screws | 10 | Nos

Now this sheet needs to be split into 2 sheets -

a. Sheet 1

Fan | 1 | Nos

_______________

Blades | 3 | Nos

Motor | 1 | Nos

Screws | 10 | Nos

b. Sheet 2

Motor | 1 | Nos

_______________

Wires | 3 | m

Plates | 2 | Nos

Further details given in the attached excel sheet. Since the excel sheet contains more than 100,000 rows, speed of execution of code will be important. If needed the output excel file can be split into files with 100 sheets each. We will need the source code as well.

技能: Excel, Excel Macros, Excel VBA

查看更多: excel macro transform data, excel macro import data project, write excel macro read data pdf files, write script macro copy data website excel, excel macro moving data cell cell, excel macro internet data, excel macro oracle data entry, excel macro refresh data, excel macro returning data try, excel macro cut data, excel macro web data read, excel macro paste data, excel macro copy data windows application, excel macro enter data database, excel macro copy data column, excel macro move data existing cell

关于此雇主:
( 0个评论 ) Mumbai, India

项目ID: #16516891

授予:

vaidyag

HI, I am an expert in Excel Macros and formula. I have understood your performance requirement and will be able to come up with solution which addresses problem. I have worked in Infosys a top IT services compan 更多

₹4444 INR 在2天内
(4条评论)
2.8

36 威客就此工作平均出价 ₹6772

schoudhary1553

Hi there..... Warm Greetings We came along with your request for Write an Excel Macro to transform data and we reviewed your project description. We'd like to help you with confidence and satisfying results... 更多

₹9000 INR 在3天内
(216条评论)
7.3
₹11111 INR 在3天内
(104条评论)
6.0
narsim3128

With respect to this project I would like to present myself as a candidate for your consideration. I have more than 8 years of IT experience. I have successfully completed few projects which involved Programming, scrip 更多

₹8888 INR 在3天内
(37条评论)
5.1
royalcalif

Hi Mr. Employer, Glad to contact with you. I can do this project through effective manner with 100% accuracy fulfilled your requirements. I assured that i have provide you 24/7 communication support during the projec 更多

₹1500INR 在1天里
(48条评论)
5.0
dvcontact

Hi, You won’t make the right candidate selection without knowing what your project about transforming BOM data of multiple items in one sheet to separate sheets will look like. Fortunately, I can show you how your job 更多

₹5000 INR 在3天内
(22条评论)
5.1
periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered twelve excel vba projects in the past three months. Willing to take up your project. Thank you, Regards.

₹12500 INR 在3天内
(18条评论)
4.3
supper5guy

Hello there, after reading your project description and with a drive for excellence, with a keen attention to details and with more than 10 years experience working with Microsoft office especially excel vba, i can do 更多

₹4444 INR 在3天内
(23条评论)
4.1
gsanggara

Dear Sir/Madam, My Name is Angga, I'm Full-time freelancer. With my time availability, I am guarantee the quality of work with 100% accuracy will be delivered timely. My clients are happy with my work quality and 更多

₹8000 INR 在3天内
(15条评论)
3.5
supergana

This needs to be done intelligently with a bingo algorithm seperating the levels of BOM. I have worked in Infosys for 18 years and even hold 2 patents in US. I can give it a shot if project is awarded to me.

₹8333 INR 在3天内
(5条评论)
3.2
soltecke

Regards, We are dedicated to the development of tools and solutions for SMEs and general users using the powerful excel tool. We also do not dedicate to statistical analysis and data science. We can develop 更多

₹3888 INR 在3天内
(1条评论)
3.0
prasannjeetp

My key skills are relevant to this project. I have huge experience in this area. I can do this project very efficiently.

₹1750INR 在1天里
(9条评论)
3.3
super2lao

Hi, Dear Employer! How are you? I am really interested in your project. I have enough experience on Excel Macro, C/C++, C#, java programming. I am 100% sure i can satisfy your requirements perfectly. I want a lon 更多

₹11111 INR 在3天内
(1条评论)
2.6
hsingla85

Available Immediately | MS Excel Expert | MBA | Assured accuracy and minimum turnaround time | VBA Expert | Excel Transformations | Will give you the code to do this repeatedly if required Looking forward for you 更多

₹7777INR 在1天里
(4条评论)
2.7
lherreraz

Hi there! I read the project's description and I'm sure that I can help you with this. I have a large experience working with advanced Excel, using formulas and Macros using VB, the most important thing is that I can d 更多

₹5000INR 在1天里
(6条评论)
2.4
cristiancpinto

vba code that reorganize the data and split in multiple files with a predefined name and a secuence number.

₹1500 INR 在3天内
(1条评论)
1.1
madalinac8

Hello, You can check my portfolio here on freelancer to see some of my previous work using Excel macros. My bid contains the final price and time I need to deliver this. Best regards, Madalina

₹2250 INR 在4天内
(1条评论)
0.6
SunniaImran

Urgent Services of Data Entry Web Search Document Formatting Creating Excel Sheet Microsoft PowerPoint etc …………….. Dear Client: If you are in the searching of right FREELANCER for your project then you a 更多

₹7777 INR 在3天内
(0条评论)
0.0
djarian99

I have extensive experience in working with Excel macros and have also developed macros to accomplish complex engineering tasks,

₹9444 INR 在2天内
(0条评论)
0.0
ramdas31

A proposal has not yet been provided

₹12222 INR 在6天内
(0条评论)
0.0
rrsathishkumar

Hai I am specialist in excel macro. I can automate what ever you need in excel. I am 200% sure i can do that why because i am currently in that same domain. I waiting for your acceptance from you. Please provide c 更多

₹8888 INR 在5天内
(0条评论)
0.0