Simple excel macro

$10-30 USD

Completed

Posted

over 5 years ago

$10-30 USD

Paid on delivery

In need of a simple macro in excel which formats multiple columns into three columns according to a certain pattern. File: The "Data"-sheet contains the raw-data which i want formated into the second sheet "Magmi". The result need to be based on the amount in column A "sku" in the "data"-sheet. There's a sample result in the "magmi" sheet now with values from columns C and D, but we want the script to do the same for all columns. What we want the script to do: Copy the amount in column A as well as the values in column C into column B and C of sheet "magmi", then i want the value of C1 from "data" sheet to fill column A in "magmi" sheet. Repeat until the values from all columns C-Q in "Data" sheet are copied the same amount of times as the amout of values in column A in "Data" sheet together with the value from row 1 "Data" sheet into the "Magmi" sheet.

Project ID: 17670964

About the project

17 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@vmadhavan15

am not a random bidder.. Please ping meif you are intersted with my proposal.. share more detail. thank you..

$30 USD in 1 day

4.9

(29 reviews)

5.1

17 freelancers are bidding on average $28 USD for this job

@schoudhary1553

Hello Sir, I am the expert freelancer here. I am on the 6th position through out the world to deliver the quality job. I have deliver here more than 395 + projects with 100% client satisfaction. I can help you with Simple excel macro I have more than 5 years of the experience in Excel, Excel Macros, Excel VBA, Visual Basic Please ping me for more discussion. Thanks.

$50 USD in 1 day

5.0

(294 reviews)

7.7

@Tanmoy236

"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed more than 190+ jobs on Freelancer majority of which was 5 star work. I understand the value of deadline and do not compromise on quality. I believe I can do a great work for you and ensure your complete Satisfaction. I am a Business (MBA) Graduate with major in Finance and MARKETING along with 5 years of experience in different analytical roles. Currently I am working for a MNC as an B2B Analyst Manager.I believe I can do a fantastic work for you if you provide me the opportunity. """

$50 USD in 1 day

4.9

(183 reviews)

6.7

@dvcontact

Hi, Reading your project description about creating an Excel macros that formats various column into three column makes me feel like you have me in mind when creating the project. I have all it takes to deliver. Before you award this project, I can complete a part of this project as a sample. This is so that you can be confident of the hands you will entrust this task. If you are satisfied with the result, you can go ahead and award the project. Please refer to my reviews to see why all my clients love my job. Do you want me to start working on the sample?

$30 USD in 1 day

4.8

(41 reviews)

6.0

@prasannjeetp

Hi, I have seen your proposal. I am an excel expert with very good knowledge of VBA. I can do this task Please come on chat for more details. Awaiting your response. Thank you.

$30 USD in 1 day

4.3

(41 reviews)

4.5

@Mfaisalshahzad00

I can do it now for you. Thanks

$30 USD in 3 days

5.0

(18 reviews)

3.9

@rIbrarahmed

hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I feel fit myself for this project. please contact with me. Thanks.

$25 USD in 1 day

4.2

(8 reviews)

3.2

@rubal45

i can do i can do i can do i can do i can do i can do i can do i can do i can do i can do i can do i can do i can do i can do i can do i can do i can do i can do i can do i can do i can do i can do i can do i can do i can do i can do i can do i can do i can do i can do i can do i can do i can do i can do i can do i can do i can do i can do i can do i can do i can do i can do i can do i can do i can do i can do i can do

$25 USD in 1 day

5.0

(2 reviews)

1.0

@roshanasim

After carefully reviewing the experience requirements of the job description, I feel that I am a suitable match for the job. I’ve held several data entry positions that entail inputting customer requests, inquire, and tracking codes of products, I also perform administrative duties including copying and faxing documents, answering telephones, transferring data, web research and reports to immediate supervisor. I feel that I can add professionalism and accuracy to your current team of professionals.

$30 USD in 1 day

0.0

(0 reviews)

0.0

@svgames72

Hello sir i read your project description. I'll complete that Simple excel macro project. Do not worry if I have less review. I have good experience in Data Entry. If I tell you this, I can reveal my talent if I get the chance. Everyone with your project-in experience might have been at the beginning without review but they got a chance and they got a review. I ask you a chance to show me my experience. I'll finish the project better than you expected. Will you give me this opportunity?

$10 USD in 1 day

5.0

(2 reviews)

0.0

@butalidjenn

I am interested on this project. I am a job oriented individual and can submit task in a timely manner. I can ensure a quality work. Thank you

$15 USD in 1 day

0.0

(0 reviews)

0.0

@vikptbar

Hello! I have experience in Microsoft Excel and Visual Basic for Applications. I can create a macro on VBA for you in short time. Clear code with comments guarantee!

$25 USD in 3 days

0.0

(0 reviews)

0.0

@gjermshus

Professional BI-consultant with extensive Excel experience from Norway. Doing small projects for fun!

$30 USD in 1 day

0.0

(0 reviews)

0.0

@rahulrex87

I can help you with the macro task quickly

$20 USD in 1 day

0.0

(0 reviews)

0.0

@ankitstudy88

Hello! I have a good idea of excel, I have made such spreadsheet as per your demand in which we can relate data of one sheet to data of another sheet,so I can say that I can do your work very well and also If I take your project, I can assure you that you will not feel regret.

$20 USD in 1 day