Write an Excel Macro to transform data

₹1500-12500 INR

Ολοκληρώθηκε

Αναρτήθηκε

περίπου 6 χρόνια πριν

₹1500-12500 INR

Πληρωμή κατά την παράδοση

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

Ταυτότητα εργασίας: 16516891

Σχετικά με την εργασία

34 προτάσεις

Απομακρυσμένη Εργασία

Ενεργός/ή 6 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Διεύθυνση Email

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα

Πληρώσου για τη δουλειά σου

Περίγραψε την πρόταση σου

Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν

Βραβεύτηκε στον/στην:

@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 company for more than 10 years and now i have started on my own. As part of my infosys tenure i have been working with Microsoft as customer delivering projects in MS technologies. Will be able to leverage this experience to deliver this project successfully. Thanks Regards Vaidy

₹4.444 INR σε 2 ημέρες

5,0

(15 αξιολογήσεις)

5,3

34 freelancers δίνουν μια μέση προσφορά ₹6.697 INR για αυτή τη δουλειά

@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... We have professionals working here with 100% results and more creative and renovative ideas for our clients ! We have worked on several similar projects before! We are offering our services for more than 5 years in the field of Excel, Excel Macros, Excel VBA We have worked on 300+ Projects. Please check the profile reviews Feel free to message us to discuss briefly about your project !

₹9.000 INR σε 3 ημέρες

4,9

(306 αξιολογήσεις)

7,8

@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 will look like before you award the project. I can tell you about how highly experienced and multi-talented I am. But I’m sure you need more than that. In less than 24 hrs, I will complete a sample part of the job before you award the project so you can be sure you’ve entrusted your job in the best hands. No commitments required! Hope to hear from you soon

₹5.000 INR σε 3 ημέρες

4,9

(50 αξιολογήσεις)

6,3

@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.

₹12.500 INR σε 3 ημέρες

5,0

(103 αξιολογήσεις)

6,2

@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 the best job in the least time starting right now. I will do all and extra to ensure that you won't regret giving me this project. Please, message me and let us discuss more about your project. Thanks

₹4.444 INR σε 3 ημέρες

5,0

(82 αξιολογήσεις)

5,8

@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, scripting, excel, vba. Looking forward to hear from you. Regards

₹8.888 INR σε 3 ημέρες

4,9

(38 αξιολογήσεις)

5,7

@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.

₹8.333 INR σε 3 ημέρες

4,9

(25 αξιολογήσεις)

4,8

@prasannjeetp

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

₹1.750 INR σε 1 ημέρα

4,4

(46 αξιολογήσεις)

4,6

@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 do the job, quickly and well done. Please, contact me and let's talk about how I could help for your project.

₹5.000 INR σε 1 ημέρα

5,0

(15 αξιολογήσεις)

3,8

@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 keeping them satisfied is always my top priority Really very much interested to have your project & looking forward for long term relationship. I have read the desc, take a look the attachement file and understand your needs. Feel free to message me to discuss briefly about your project, looking forward to hearing from you soon. Warm Regards, GS Anggara

₹8.000 INR σε 3 ημέρες

4,8

(23 αξιολογήσεις)

4,0

@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 are at the RIGHT place. Welcome to MY Profile

₹7.777 INR σε 3 ημέρες

4,5

(12 αξιολογήσεις)

3,8

@hsingla85

₹7.777 INR σε 1 ημέρα

5,0

(8 αξιολογήσεις)

3,4

@FaizanAli1122

I am expert in this field....... your satisfaction is my priority.... lets see more in chat.......................

₹1.650 INR σε 3 ημέρες

5,0

(3 αξιολογήσεις)

2,4

@super2lao

Σημαία της LAO PEOPLE'S DEMOCRATIC REPUBLIC

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 long term relationship with you. Thank you and best regards!

₹11.111 INR σε 3 ημέρες

5,0

(1 αξιολόγηση)

2,6

@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

₹2.250 INR σε 4 ημέρες

5,0

(2 αξιολογήσεις)

1,3

@cristiancpinto

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

₹1.500 INR σε 3 ημέρες

5,0

(1 αξιολόγηση)

1,1

@rsundar123

A proposal has not yet been provided

₹1.750 INR σε 1 ημέρα

5,0

(1 αξιολόγηση)

0,0

@Ashraf5426

Hello, I am an Excel Visulization & Automation expert, with over 14+years of experience using Excel in various projects. Mainly focused on Finance and Investment Banking. I can get the job done to your complete satisfaction in shortest time, I will also provide the source code. If you have any questions, please feel free to write back. Many Thanks, Ashraf Khan

₹22.222 INR σε 3 ημέρες

0,0

(0 αξιολογήσεις)

0,0

@sudhiryadav187

Having good experience of MS Excel. Completed Advanced Excel Course and completed many projects within the time frame.

₹2.250 INR σε 2 ημέρες

0,0

(0 αξιολογήσεις)

0,0

@healthmonkey

Hi, I just came across your job offer and I am intersted in helping you. I am very experienced in data transforming using Excel and in particular the automation of it using VBA. As your file is really big, I would consider outsourcing the file to a database (for performance reasons) - but a pure Excel solution is also possible. I work fast and reliable. Please contact me to discuss details. Philipp

₹1.500 INR σε 3 ημέρες