176985602337900

Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

VBA Merge Macro
Sign in to Add to Watch List

IT & Programming > Other IT & Programming

View Change History

The client has made the following changes to the job.

Description
Date

Job awarded.

Mar 2, 2013

Bidding period ended early.

Mar 2, 2013

Job awarded.

Mar 2, 2013
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Sat, Mar 02, 2013
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:
    Anywhere

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Hourly Rate: About $16 / hr
  • Hrs/wk: Not Sure | Duration: 3 hrs
  • Work View™ Payment Protection
  • W9 Not Required
Sign in to view client's details

I have a workbook (attached) which has multiple records for a single order # (column c)

Look at rows 6-7. You will notice the info in A-F and AK-AM is the same.

The other fields in between have either a 0 or 1.

We want to "merge" rows so that there is only 1 row per order #

The data from A-F and AK-AM is the same in each line so you can keep the first instance. Column K as well. Column AJ can be deleted.

With the other cells between we want to get a sum. Example:

1 0 0 0 0 1 0 0 1 0 0 0
0 0 1 0 1 0 1 0 0 0 1 0

1 0 1 0 1 1 1 0 1 0 1 0 is the result

Sign in or Register to see more

Desired Skills
VBA, Visual Basic, Excel
Job ID: 38517729
Proposals
Hourly Rate: Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

We have strong knowledge in Excel, Spreadsheet, VBA Macro.
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 38521038  |  Submitted: Mar 2, 2013 14:42 ET 
Proposal SEALED

Yosi Segal      
Yosi Segal's identity has been verified.  Learn More
 Israel  |  
Programming in VBA for Office applications. Excel expert. 10 years industrial experience.
4
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 38519490  |  Submitted: Mar 2, 2013 13:39 ET 
Proposal SEALED

Muhammad Abdullah      
Muhammad Abdullah's identity has been verified.  Learn More
 Pakistan  |  
I specialize in solutions development using Microsoft Technologies for Windows, .NET, Web & Azure cloud platforms. Experienced in C/C++ (Win32,...
8
  |  
 4.9   |  Private   |  17 Jobs
Bid ID: 38519179  |  Submitted: Mar 2, 2013 13:27 ET 
Proposal SEALED

Anish Kumar      
Anish Kumar's identity has been verified.  Learn More
 India  |  
6+ years of extensive experience im Report/Process automation and solution development using VBA, Macro, C#. I have developed more than 300...
4
  |  
 4.8   |  Private   |  31 Jobs
Bid ID: 38518418  |  Submitted: Mar 2, 2013 12:59 ET 
Proposal SEALED

Goran Dolenc      
Goran Dolenc's identity has been verified.  Learn More
 Slovenia  |  
Winner
Expert in VBA automation and optimization!
3
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 38518412  |  Submitted: Mar 2, 2013 12:59 ET 
$40.00/hr

 United Kingdom  |  
Winner
IT Professional with 20 year experience in many disciplines across many industries. Industries I have developed acrross Data cleansing, analysis,...
7
  |  
 5.0   |  Private   |  17 Jobs
Bid ID: 38518109  |  Submitted: Mar 2, 2013 12:49 ET 
$19.99/hr
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »