176985602337900

Find freelancers. Lose those costly delays.

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

or, Register with Elance »

CSV Bot Modification Barcode Needed
Sign in to Add to Watch List

IT & Programming > Software Application

View Change History

The client has made the following changes to the job.

Description
Date

Job awarded.

May 12, 2012
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Fri, May 11, 2012
  • 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
  • Budget: $100 or less
  • Fixed Price Job
  • Elance Escrow Protection
  • W9 Not Required
Sign in to view client's details

We have a csv input (bestsellers.csv) - attached and we use the csv to do a quantity list using a VBA script in an excel file (ShinyNewCSVImportMark4.xls) - attached. The current output (output.xls) - attached

We need some modification in the script.

1. There should be only 5 columns of products -Within A4 width. This is to give more space/width for Barcode. Right now, it is 7 columns. The row number of 6 is to remain same.

2. If the QTY is 2 for a specific SKU, The item should be displayed twice. One after another.
If ther Qty is 3, then the item (scraped data) should be displayed thrice. One after another. See attached image, "2 in a row.jpeg"

3. I don't need the name and price field details on the output. Just need the SKU field. And below the SKU Field, The 2 rows of space should be used to display the Barcode corresponding to the SKU. Please see the attached image - "Final.jpeg" for the idea.

Please let us know if this changes can be done.
It should be a rather simple pro...

Sign in or Register to see more

Desired Skills
VB.NET, VBA, Visual Basic, C#, C++
Job ID: 30475816
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 Egypt  |  
INVITED
I am fully qualified to do the following: 1- Excel, Word and outlook scrips and programs(VBA macros). 2- New excel Functions creation. 3-...
4
  |  
 5.0   |  Private   |  1 Jobs
Bid ID: 30484223  |  Submitted: May 12, 2012 02:50 ET 
Proposal SEALED

 India  |  
Expert programmer with multiple skills... 1. Office Automation - MS Excel Expert with deep knowledge of VBA/Macros and Formulas. Extensive...
7
  |  
 5.0   |  Private   |  5 Jobs
Bid ID: 30483552  |  Submitted: May 12, 2012 01:46 ET 
Proposal SEALED

 China
INVITED
Good at VBA development for EXCEL,Word,Access, PowerPoint, Outlook. Developed over 200000 lines of code in Visual Basic 6, C#.net, VB.net and other...
2
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 30479668  |  Submitted: May 11, 2012 17:29 ET 
Proposal SEALED

 Greece  |  
Winner
Native Greek professional translator (English to Greek). Experience: more than 20 years cooperator of M. Giourdas Publications (Greece),...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 30477406  |  Submitted: May 11, 2012 15:18 ET 
Delivery
Within 3 days
$95.00

 India  |  
INVITED
I request all clients to please see my LIFETIME data and feedback rating on elance. Or you can follow the links below...
3
  |  
 5.0   |  Private   |  4 Jobs
Bid ID: 30476389  |  Submitted: May 11, 2012 14:30 ET 
Proposal SEALED

 India  |  
Microsoft certified programmer. Expert in software development using .Net technologies C#, ASP.NET, WPF, WCF, Windows form, Web services, SQL...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 30476330  |  Submitted: May 11, 2012 14:27 ET 
Proposal SEALED
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 »