EXCEL Spreadsheet Guru Needed

See attached Spreadsheet:
I have a spreadsheet with 577 rows. As an example, I have one column of Categories in text, and I need the corresponding Category Code placed in the adjacent cell with the codes separated by commas.

Like this:
Category Text: Longevity Plus, All Products, Energy Support, Immune Support, Energy, Antioxidant

Category Codes: 2191,1819,2107,1961,2030

Even using find and replace, it will take too long. This is best done with an automated find and replace macro, which should be able to be done in 30 minutes if you know EXCEL Macros! The attached sheet has the corresponding codes in the second worksheet in the workbook, the first has the Category Text.
I need this done in 6 hours from this posting.

Search All Jobs:

Ongoing Data Entry - Work Every Day

We have a database of people who are applying to college and have requested information from a school. We need to fill out a request for information on a partner site for each application. There will be 50-75 of these per day. We will provide the data in the spreadsheet attached...

Skills Required: microsoft-excel spreadsheets
  • Fixed Price Project
  • Max $650
  • 5 months, 1 week left

Mental Labs

Mental Lab is like having a thinking hat on, but not with this. This is for people to make a image in their minds. Like rooms in a house but it will be a pyramid and an underground rooms. Each room has it on subjects...

  • Fixed Price Project
  • Max $5
  • 1 year, 5 months left

Foreclosure Paralegal / Legal Clerk

The Paralegal will report directly to the General Counsel, performing Paralegal functions of a variable, complex problem solving and responsible nature which require a significant degree of knowledge, decision-making skills and independent judgment...

  • Fixed Price Project
  • Max $150
  • 4 months, 3 weeks left

Experienced Real Estate Investor Assistant

Email Seller Leads Respond to seller calls in Google Voice as they come in...

  • Fixed Price Project
  • Max $500
  • 3 weeks, 6 days left

Expert MS Access And VBA Developer Needed With Demonstrable UML Experience In MS Visio.

Currently there is an application that was built in MS Access using VBA by one developer. Due to the complexity of the application and there only being one developer for this application, we are looking to expand development on this application...

  • Fixed Price Project
  • Max $5
  • 3 months, 4 weeks left

Publisher PDF Newsletter Publishing And Design

Our Association is looking for a company or person with depth to take our content and photos and utilize their skills to use MS Publisher to produce a monthly NL for us. The size and scope of the NL is 20-35 pages...

  • Fixed Price Project
  • Max $50
  • 2 weeks, 4 days left

Cold Callers

We need cold callers, you will be provided with leads, the excel format, and a Script. You must be comfortable deviating from the script. I will pay .50-1.00 per YES I am interested answer (will be verified) and .05 to .10 per NO call. After the test job you will get a bonus of 1.99 to pay for sk

  • Fixed Price Project
  • Max $500
  • 1 month, 4 weeks left

Personal Finance Assistant Needed

Open to your ideas if you have a better one, I've included a l of detail just to describe this at a high level. I need a very simple system to track my family basic personal finance information due to extremely limited time constraints...

  • Fixed Price Project
  • Max $5
  • 4 months left

ASP.NET Developer Bucharest

This is a full time job which requires on site presence here in Bucharest. POSITION GOALS Development and maintenance of the transactions systems applications. DAILY TASKS: "

  • Fixed Price Project
  • Max $1400
  • 3 months, 4 weeks left

Newbie Punjabi Translator (only Indian)

we need Punjabi translator for translation for regular projects. (No Pakis, bangladeshi people please) It will be a permanent job as long as you want ! We will pay you 50 Rs for 250 to 299 words as per your quality. which may be increased. We also pay bonuses upto 50% if we liked your job...

  • Fixed Price Project
  • Max $50
  • 1 week, 4 days left

Job Details

  • Job Type
  • Fixed Price Job
  • Budget
  • Max $11
  • Start Date
  • 05/01/2012 06:10:30 AM
  • Job Status
  • Job Expired