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 modification (vba,php,sql)
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.

Feb 8, 2013
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Fri, Feb 08, 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
  • Budget: Not Sure
  • Fixed Price Job
  • Elance Escrow Protection
  • U.S. freelancers must have W9
Sign in to view client's details

I want to get the following job done and need a vba script for that.

I have 300,000 (3 lacs) records in a file. In column B (the city-names), there are 400 unique values. I want the script to identify these unique values (ex. Bombay, New York, San Francisco) and replace them with incrementing strings (ex. city1, city2, city3 and so on...). Then the script should store the mapping of the previous values and the new values (ex. Bombay->city1, New York->city2 etc.) in a new worksheet in the same spreadsheet.

Sign in or Register to see more

Desired Skills
VBA
Job ID: 37676931
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 Russia  |  
Programming, C/C++, MFC, .NET, Labview, device drivers, Arinc429, MIL-STD-1553B, C#, VB.NET, Delphi, win32
2
  |  
 4.7   |  $214 Earnings   |  4 Jobs
Bid ID: 37677781  |  Submitted: Feb 8, 2013 15:59 ET 
Proposal SEALED

 Egypt  |  
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: 37677741  |  Submitted: Feb 8, 2013 15:57 ET 
Proposal SEALED

Marwan T.      
Marwan T.'s identity has been verified.  Learn More
 Jordan  |  
Excel is my passion, my analytical personality along with a systematic way of thinking that was gained through years of study and work experience...
2
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 37677730  |  Submitted: Feb 8, 2013 15:57 ET 
Proposal SEALED

ZenStar I.      
One or more team members at  are verified.  Learn More
 India  |  
Winner
Dynamic professionals with over 12 years of experience in Product Development, Applications Development and Team Management in IT Industry....
7
  |  
 5.0   |  $3,220 Earnings   |  9 Jobs
Bid ID: 37677180  |  Submitted: Feb 8, 2013 15:33 ET 
Delivery
Within 1 day
$21.92
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 »