Find freelancers. Lose those costly delays.

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

or, Register with Elance »

Excel Macro - Change Dimensions
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 awarded.

Nov 7, 2012

Job Description

  |  Change History >>


  • Posted: Wed, Nov 07, 2012
  • Time Left: Closed
  • Location: United States
  • Client prefers freelancers from:
    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

We need straightforward Macros.

Task One:
We have an excel worksheet with 3754 rows, and there are data on every 8th row. On each of the 8th rows, Columns A, B, and C are variations on the same dimension, such as 9x9, 9 x 9, and 9" x 9".

Columns D, E, F, G, and H each have sentences or phrases that use one or more of the dimension formats in columns A, B, and C.

The task is to replace the dimension in Columns D,E,F, G, and H with the appropriate version of the dimension in Column A, B, and/or C of the same row.

Task Two:
A different excel worksheet has 3754 rows, and there are data on every 8th row in Column A. The data are dimensions such as 9 x 9.

Cells B2, B3 and B4 have sentences that use the dimension in A2; Cells B10, B11 and B12 have sentences that use the dimension in A10; Cells B18, B19 and B20 have sentences that use the dimension in A18 and so forth.

The task is to complete column B using the same pattern.

On each of the two worksheet, cells have been ...

Sign in or Register to see more

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

 Lithuania  |  
I am a programmer experienced in MS Excel, Visual Basic, PHP, MySQL, Javascript. I have completed many programming projects over the past few years...
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 35014031  |  Submitted: Nov 7, 2012 11:21 ET 
Proposal SEALED

Pradip N.      
Pradip N.'s identity has been verified.  Learn More
 India  |  
EXCEL, WORDPRESS, IBM DataPower, WTX, JavaScript, XML, XSLT, Data Extraction, Admin Work, SQL.
 4.7   |  Private   |  23 Jobs
Bid ID: 35013896  |  Submitted: Nov 7, 2012 11:17 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 »