Đã hoàn thành

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.

Kĩ năng: Excel, Excel Macros, Excel VBA

Xem nhiều hơn: 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

Về Bên Thuê:
( 0 nhận xét ) Mumbai, India

ID dự án: #16516891

Được trao cho:

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 Thêm

₹4444 INR trong 2 ngày
(4 Đánh Giá)
2.8

36 freelancer đang chào giá trung bình ₹6772 cho công việc này

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... Thêm

₹9000 INR trong 3 ngày
(216 Nhận xét)
7.3
₹11111 INR trong 3 ngày
(104 Nhận xét)
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 Thêm

₹8888 INR trong 3 ngày
(37 Nhận xét)
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 Thêm

₹1500 INR trong 1 ngày
(48 Nhận xét)
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 Thêm

₹5000 INR trong 3 ngày
(22 Nhận xét)
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 trong 3 ngày
(18 Nhận xét)
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 Thêm

₹4444 INR trong 3 ngày
(23 Nhận xét)
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 Thêm

₹8000 INR trong 3 ngày
(15 Nhận xét)
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 trong 3 ngày
(5 Nhận xét)
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 Thêm

₹3888 INR trong 3 ngày
(1 Nhận xét)
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.

₹1750 INR trong 1 ngày
(9 Nhận xét)
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 Thêm

₹11111 INR trong 3 ngày
(1 Nhận xét)
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 Thêm

₹7777 INR trong 1 ngày
(4 Nhận xét)
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 Thêm

₹5000 INR trong 1 ngày
(6 Nhận xét)
2.4
cristiancpinto

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

₹1500 INR trong 3 ngày
(1 Nhận xét)
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 trong 4 ngày
(1 Nhận xét)
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 Thêm

₹7777 INR trong 3 ngày
(0 Nhận xét)
0.0
djarian99

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

₹9444 INR trong 2 ngày
(0 Nhận xét)
0.0
ramdas31

A proposal has not yet been provided

₹12222 INR trong 6 ngày
(0 Nhận xét)
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 Thêm

₹8888 INR trong 5 ngày
(0 Nhận xét)
0.0