Basic Excel Macro / VB


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: vba and macros, excel 2013 vba, Visual Basic Excel, vba macros, vba excel macro, vb excel, simple macro, macro vba, EXCEL MODEL, Excel Macro VBA, excel duplicate, Excel and 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

Project ID: #5076499

21 freelancers are bidding on average $27 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)

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

$30 USD in 1 day
(63 Reviews)

I can give u application for this. You will simply select excel file from application and click on output button on application and you will get ouput excel file as u described. See sample applications below: htt More

$35 USD in 1 day
(23 Reviews)

Hi, Today's Date is : October 30, 2013 Please share your excel file that contains the macro that I can look into it and modify it if required. Otherwise, I will create a new macro/VBA code so then you can run it More

$35 USD in 1 day
(51 Reviews)

Sir, I am well versed in this kind of jobs and can do your project as per requirement. Refer my online work portfolio at Looking for further discussions in this matter. with than More

$29 USD in 3 days
(23 Reviews)

Today is 30-10-13 in India. I am an Excel expert and can complete the project with 100% accuracy. Please take a look at my reviews for Excel projects.

$19 USD in 1 day
(60 Reviews)

Hi there. Its 30th October 2013. Its a 20 mins job for me. Kindly share the file and you shall have it back in no time. 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

$25 USD in 3 days
(24 Reviews)

(30-Oct-2013) Hello ,Hope you are doing great, I have read the details and understood the requirements, I am ready to start ASAP and will be able to complete the task very soon, I will be charging $25 for this task More

$25 USD in 0 days
(11 Reviews)

I can do this work, please share the document and i would ready to share the sample list. Waiting for your response . I will complete this work in few hours

$25 USD in 1 day
(32 Reviews)

VB, VBA and Databases expert for over a decade. Master in Information Systems. I have delivered similar projects in the past. Please send me all the details of your project plus the files before you award anyon More

$17 USD in 3 days
(4 Reviews)

I can give that macro in less than an hour if you could award soon. today's date 10/31/2003 -----------------------------------------------------------------------------------

$30 USD in 1 day
(7 Reviews)

Please give me your excel sheet. I will make the macro to do this job after you accept my bid. Thanks. Today my local date is 31-Oct-2013 and time is 10:05 AM ( GMT + 5 ). Thanks.

$10 USD in 1 day
(14 Reviews)

Hello. Today's DATE IS 30.10.2013 I can complete the task,But i want to know what is the time limit for this project Thank You Regards Ruma Paul

$30 USD in 3 days
(4 Reviews)

Hi, today is 30 October 2013. I can easily do what you need right away. I have 12 years of Excel experience. Do you need the macro or formulas, or just the output file? Please also note that attachment is missing from More

$17 USD in 0 days
(5 Reviews)

30-OCT-2013 IST Hi I can start it Immediately there is no file i the attachment.... regards Nikhil

$38 USD in 3 days
(2 Reviews)

Hi, I have a very quick internet access 24/7 and 2 laptops to work with. Job will be done perfectly on excel sheet properly formatted as per your instruction. I have many experience in data mining, data entry, data pr More

$25 USD in 3 days
(1 Review)

29/10/2013 can be done immediately Hello thank you for the opportunity Working on Excel for over 11 years now. Look forward to haering from you Thank you Malini

$10 USD in 0 days
(1 Review)

i have 8+ years of experience. Can we discuss the project. Please initiate a chat with me so that we can discuss the project at a broader level

$64 USD in 3 days
(1 Review)