176985602337900

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.

Description
Date

Job awarded.

Nov 7, 2012
Close

Job Description

  |  Change History >>

Updated

Close
  • 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
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 Lithuania  |  
Graduated from Vilnius University. In 2011 I studied intensive five months long Information technology courses at the Vilniaus Kolegija /...
1
  |  
 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, Data Extraction, SQL, Data Entry, ETL, Admin Work, Virtual Assistance, Database Handling, HTML, Photoshop
2
  |  
 4.3   |  Private   |  29 Jobs
Bid ID: 35013896  |  Submitted: Nov 7, 2012 11:17 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 »