Basic Excel Macro / VB - repost

I have a spreadsheet of 3000 lines. It contains only a few columns and is very simple to understand. I've attached a very easy to understand example.

Basically I need a concatenation of all the lines which contain the same SKU.

I need the year and model columns concatenated where for all duplicate SKU, and combined into a YEAR and MODEL cell, only ONE YEAR and MODEL per SKU, and then duplicate years and models removed from that new concatenated cell. With the proper macro this should not take more than an hour, I have two macros that can do this, but I have never experimented with VBA inside of Excel, and would rather pay to have it done properly, and in a quick amount of time.

This is time sensitive, and is not a difficult project. Should be easy money.

Do to the amount of copy and paste spam on project bids, please include today's date in your bid. Thank you.

Skills: Excel, Visual Basic

See more: excel 2013 vba, vba macros, vba excel macro, vb excel, simple macro, macro vba, excel model, excel macro vba, excel duplicate, excel vba, vba excel copy, macros excel basic, excel copy vba macro, 2013 excel visual basic, simple vba macro, excel 2013 visual, excel 2013 macro, macro vba cell, macro spreadsheet, excel vba spreadsheet, copy paste macro vba, excel vba macro spreadsheet, cell excel vba, excel vba cell, example visual basic

About the Employer:
( 9 reviews ) Appleton, United States

Project ID: #5076509

25 freelancers are bidding on average $28 for this job


Hello nmanderfield :) I am an VB / Excel Expert. If you see my reviews by navigating to this link then you will notice th More

$30 USD in 0 days
(124 Reviews)

Date is 10/30/2013 I have gone through the details and understood the requirement. Just one question, the column F will have duplicate values and macro will concatenate the exact duplicate not the similar one. I More

$53 USD in 2 days
(42 Reviews)

Today: Oct 30th Can be done now ==========================================================================

$30 USD in 1 day
(63 Reviews)

can provide you the consolidated data in the form of presented format. Infact, if you could have provided data, can process and revert back with the solved solution. Do look at my profile and the efficiency and rehire More

$30 USD in 0 days
(16 Reviews)

Hi nmanderfiled, Had a look at the example screenshot and I can take on the job. Please confirm and provide sample file. Shall deliver the macro within a day. Regards, Arul Date : 30 October 2013

$30 USD in 1 day
(102 Reviews)

Dear Sir Please send me the file.. First I will do it. Then you can check and confirm. and if you are satisfied, you can offer me the job ;-)) I'm waiting............. Thanks Priyal

$30 USD in 0 days
(67 Reviews)

Today's date is 30th Oct 2013. Hi, Let me introduce myself as an expert Excel Macro programmer. I have used VBA extensively for Excel, MS Word etc.. I have more than 10 years of experience to my credit. I h More

$25 USD in 2 days
(63 Reviews)

Hi I am interested to work for your project . I am an expert in excel and VBA Programming in Excel. I have experience working on lot of Excel based projects. I will make sure that I deliver you the best with 100% ac More

$30 USD in 1 day
(48 Reviews)

Hi there. Its a 20 min job. Kindly share the file and you shall have it back in no time. I do this kind of manipulations many times a day. Regards

$30 USD in 1 day
(22 Reviews)

Hello there. Today is 10/30/2013 I have high Excel and Visual Basic skills with great professionalism. I study electronics and computer engineering at Oporto university and I'm looking for work to fill the blank More

$20 USD in 1 day
(24 Reviews)

Hello - I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among n More

$30 USD in 3 days
(24 Reviews)

hello, i can do this for you. It's clear from your example. Please send me your file and i will start now.

$24 USD in 3 days
(13 Reviews)

*****I've completed Similar Projects with SKU.******* Good Day!... I'm an Expert in Excel VBA Automation. Have developed & designed More

$30 USD in 0 days
(11 Reviews)

I can do this job rapidly for you. I work with vba excel there is 4 years. I am ready to start it for you.

$14 USD in 3 days
(2 Reviews)

A proposal has not yet been provided

$30 USD in 3 days
(4 Reviews)

Hi, I can do what you need. I have 12 years of extensive Excel experience and can start working on the project immediately.

$25 USD in 0 days
(5 Reviews)

As a professional Excel developer, I will have no trouble doing this excercise for you! In fact, a macro is not necessary - you can do it with a formula, albeit a pretty complex one. The only question I need to be answ More

$25 USD in 3 days
(3 Reviews)

Hi, Today is October 30th (almost Halloween) and I'd be glad to help you with this. This is indeed a very simple automation and I would be able deliver this in maximum 2-3 hours if you award the bid this evening (i More

$25 USD in 1 day
(3 Reviews)

Date: Oct 30 , 2013 Hello, i am highly experienced vba coding macros in excel vba and will do this excellent for you!

$35 USD in 1 day
(1 Review)

Hello, I have good knowledge on Doing with Excel Macros, and Saw the Attached Document also it is easy to do, please give me a chance sir i will give good quality. Thanks

$15 USD in 1 day
(1 Review)