The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
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