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.


Job awarded.

Feb 8, 2013

Job Description

  |  Change History >>


  • Posted: Fri, Feb 08, 2013
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:

    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
Job ID: 37676931
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
 3.9   |  $49 Earnings   |  2 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-...
 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...
 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  |  
Dynamic professionals with over 12 years of experience in Product Development, Applications Development and Team Management in IT Industry....
 4.9   |  $1,946 Earnings   |  18 Jobs
Bid ID: 37677180  |  Submitted: Feb 8, 2013 15:33 ET 
Within 1 day
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 »