Excel sheet to calculate Sizes from my sheet

$30-250 USD

Completed

Posted

about 5 years ago

$30-250 USD

Paid on delivery

I have attached my excel sheet so you can see what I need. This is a partial sheet of almost 200 items, my full sheet will be 4500 items. From column A to BD (White header) is my sheet of data. From column BF to DI (Orange header) is where I need you to provide me data from my sheet. I have completed the first two parent sku's and their variations in sizes. I basically need you to create something (guessing a macro?) that gives me all of what you see there on that second sheet for all the parent sku's and their sizes and corresponding data. I have color matched where I get the data from the first sheet to the second. If you can do this for me, please place a bid.

Project ID: 18909338

About the project

24 proposals

Remote project

Active 5 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:

@gr8tech

Hello there I have seen your Excel file and I am available to provide the data required in the 2nd part of your worksheet and you have demonstrated. I have experience working with Excel/Formulas and VBA. I would like to know if you only desire the results or you need an Application which will allow you to create the same in the future. For your project, I will use VBA to reconfigure your data according to the examples you have provided and will be able to complete the work between 1-2hrs. I look forward to your response. Moosa

$55 USD in 0 day

4.9

(44 reviews)

5.5

24 freelancers are bidding on average $120 USD for this job

@schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep

$220 USD in 3 days

4.9

(367 reviews)

8.0

@P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$150 USD in 3 days

4.9

(363 reviews)

7.5

@asadkhan3533

Please review my profile as i have relevant skills and experience required for this project. Kindly send me a message to discuss further. Thanks, Asad Khan

$155 USD in 3 days

5.0

(204 reviews)

6.8

@tiaratechies

Hello, Sir with my experience I can say that I can complete this job with perfection in less time kindly give an opportunity to work for you, thank you. Note: The data can be matched and placed, I will write the code or macro depending on the source sheet, But I'm sure I can do it.

$250 USD in 2 days

5.0

(53 reviews)

7.0

@onlinejob247

Hi there, I’ve checked the project details and I can do this project perfectly. I have huge experience in working with these projects. Waiting for your quick reply. Look forward to hearing from you soon. Best Regards

$250 USD in 3 days

4.9

(129 reviews)

6.6

@mrbrave

HI, Using Excel formulas and VBA, I can complete the list within couple of hours. I will use scripts, so in case you need to change some results, it can be done quickly. I have more then 7 years of professional Excel experience and have completed more then 250 related projects here. I am available right away to work and assure you a quick and 100% accurate results. Thanks

$70 USD in 1 day

4.9

(274 reviews)

6.8

@MohsanEijaz

I have excel and vba experience. I can complete your project now MOhsan

$133 USD in 3 days

5.0

(88 reviews)

6.3

@branislavm

Hello! I am Branislav and I can help you create a list. However, I do not see this is possible with formulas, so, yes, you are right - a macro will be needed for this. It will need to loop through the records and extract the data. I will need one day to write a macro, two at most. Regards, Branislav Mihaljev

$155 USD in 3 days

5.0

(56 reviews)

6.4

@TechnoGuruu

Hi, As per requirements I will develop VBA macro for you which will process the data from sheet1 to sheet2 as per description of the project. I have expertise in Excel, formulas, Excel VBA and finished many such projects. Quality work with high accuracy and 100% customer satisfaction is guaranteed. I am ready to work on this project now. Please give me this opportunity to work on your project. Thanks and regards, Mohan

$149 USD in 3 days

5.0

(93 reviews)

6.1

@rinabuoy13

Hello, I am experienced excel expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards Rina B.

$35 USD in 3 days

5.0

(105 reviews)

6.2

@catstevens2009

Hi there! Have prior experience with excel, and am an excel expert! Please feel free to message me with additional information or with questions if any, thanks!

$55 USD in 1 day

5.0

(94 reviews)

5.6

@renesontiongson

Pleasure to help you. Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much.

$80 USD in 3 days

4.9

(74 reviews)

5.5

@jasalaz100

Hello, I hope you are well. I can to this by creating a macro the performs what you did manually, meeting a set of conditions and just with a click of a button. These are my strengths: Immediate availability. Responsible, fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after completion. Experience of 7 years using excel for organizing and analyzing any company variables. Experience on programming with VB in excel, creating any report using pivot tables and pivot charts, dashboards. Passionate about excel automation.

$200 USD in 3 days

4.9

(32 reviews)

4.8

@carlosperezit

Hi there My name is Carlos and I'm an expert in .Net and sql server. I have been working in software developement for the last 20 years. I have many experience in desktop and web development. Regards

$155 USD in 10 days

4.8

(32 reviews)

5.0

@AhmedMarzoq

I am very interesting to work and help you in your project and I am very detected and implement to provided you project on time and with high accuracy and using any advanced like pivot table or simple vba

$166 USD in 5 days

5.0

(22 reviews)

4.9

@rIbrarahmed

xhi, 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 understand the value of deadline and do not compromise on quality. I feel fit myself for this project. please contact with me. Thanks.

$45 USD in 1 day

4.7

(28 reviews)

4.9

@kyosra

Hi The task is easy I am a software engineer student I did similar tasks I agree to do a test before hiring me to convince you, I will do the attached file for free if you are satisfied I continue but I need some clarifications, contact me to discuss I am free so I can start now Thank you

$30 USD in 1 day

5.0

(14 reviews)

4.3

@gsanggara

Hi Lanemax, I am excel advance freelancer, very interested to work on your project. I have done alot of excel project for different 2 usage, please see my portofolio and client review on https://www.freelancer.com/u/gsanggara I have go through your job description, attachment file and understand your need. I will create macro to transfer data from sheet data to target sgeet as per your mentioned. Please ping me to discuss further. I am available & ready start work immediately, thank you. Best Regards, GS Anggara

$60 USD in 2 days

4.9

(28 reviews)

4.1

@tbrifki64

I would like to assist you. Kindly advice me further instructions. Thank you very much. Will be waiting your message...

$150 USD in 3 days

4.5

(13 reviews)

3.9

@CronyTech

I can do what you need. I'm expert using Excel and VBA. I have seen your file and it seems this can be done using some formulas. Please do not hesitate to contact me so we can further discuss the details of your project.

$45 USD in 5 days