Find freelancers. Lose those costly delays.

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

or, Register with Elance »

Compile Contents of Excel Row Cells (Macro)
Sign in to Add to Watch List

Admin Support > Other - Administrative Support

View Change History

The client has made the following changes to the job.


Job Description

  |  Change History >>


  • Posted: Mon, Aug 13, 2012
  • Time Left: Closed
  • Location: United States, United ...
  • Client prefers freelancers from:
    United States, United States

    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: Less than $500
  • Fixed Price Job
  • Elance Escrow Protection
  • U.S. freelancers must have W9
Sign in to view client's details

The job is to compile 4 elements from each row of a spreadsheet into a Complete Description for each row. Knowledge of html and Excel skills required. (The task might be most efficiently completed with a macro.)

Four component of the Complete Description are on an Excel spreadsheet. Column A is Green Product Title; Columns B through H are separate Bullet Points; Column I is Text Body; and Column J is Model Number. Not all rows have an equal number of bullet points.

The task for each row is to combine those four components, using cell 1A of the attached Format file as the format, and place each end result in Column K. For each row:
Replace the words GREEN PRODUCT TITLE on the Format.txt file with Column A
Replace the BULLET 1 with the contents of Column B
Replace the BULLET 2 with the contents of Column C
Replace the BULLET 3 with the contents of Column D
Replace the BULLET 4 with the contents of Column E
Replace the BULLET 5 with the contents of Column F
Replace t...

Sign in or Register to see more

Job ID: 32696649
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 China  |  
Great at Excel/VBA and other MS Office skills Finance and Progamming backgrounds 8+ years working experience in an MNC (in-service at present) 20+...
 0.0   |  Private   |  0 Jobs   |  1 verified credential(s)
Bid ID: 32697565  |  Submitted: Aug 13, 2012 10:27 ET 
Proposal SEALED

 United Kingdom  |  
I have been part of the Chemistry department of Cambridge University for almost a decade, and am currently submitting my PhD thesis. I have copious...
 0.0   |  $455 Earnings   |  0 Jobs
Bid ID: 32697464  |  Submitted: Aug 13, 2012 10:24 ET 
Within 1 day

 India  |  
Specialized in Web Scraping and Excel Macros, Black Brahma is an IT unit of dedicated software wits specialized in many other latest software...
 5.0   |  Private   |  4 Jobs
Bid ID: 32696976  |  Submitted: Aug 13, 2012 10:05 ET 
Proposal SEALED
Elance is now an Upwork company.
Upwork is the choice of 4M+ clients. Get started working on Upwork today.
Are you ready to post a job like this one?
Post a Similar Job »