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
  • 4 months, 2 weeks left

Content Writer (On-going Orders) Trial

Hi, We are currently looking for NATIVE ENGLISH content writers looking for on-going work on company/individual bios. A typical order will consist of several short and large bios on the same topic, this means writing multiple bios based upon the same company/individual...

  • Fixed Price Project
  • Max $500
  • 3 months, 1 week 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 left

Microsoft Access

I already have a database created and I would like to change and add some features to create charts and graphs from the data in the database. I do not pay any upfront. I would like for you to know VBA coding as well

Skills Required: microsoft-access vba
  • Fixed Price Project
  • Max $5
  • 1 week, 4 days left

Lotto POS Terminal Mobile Apps

Hello, We are independent IT contractors. We have a client who runs a lotto company and need the lotto POS terminal application to be designed and developed to desktop and mobile apps that must be compatible with the latest androids and smart phones iOS...

  • Fixed Price Project
  • Max $5000
  • 4 days, 6 hours left

Email Response Handler And Calendar Manager

Need someone long term who can help manage email and my calendar. Ideal candidate will be knowledgeable with google/gmail applications. There is room for growth within our company...

  • Fixed Price Project
  • Max $5
  • 2 months, 1 week left

Data Entry

I need lots of interested Data Entry operators ASAP. Who can follow instruction. After an easy interview then will be hired. It's a chance of type'r to get good feedback.

Skills Required: microsoft-word
  • Fixed Price Project
  • Max $300
  • 3 months, 1 week left

Respond To 100 Emails Per Day Using Templates

Language International needs a diligent, detail-oriented long-term contractor to draft responses to 100 emails per day from schools with whom we are interested in establishing partnerships. TO APPLY, YOU MUST COMPLETE A TEST...

  • Fixed Price Project
  • Max $200
  • 5 months, 1 week left

Seeking A Good Personal Assistant

I am seeking a Personal Assistant to help me manage my personal life: This person will help me do the following: - Search for discount flight tickets and vacation on the internet...

  • Fixed Price Project
  • Max $20
  • 2 months, 2 weeks left

Admin Job For Online Retail Company

Your job will be to create and email our shipping reports. The task is very simple and will be done in 1 click using our databse. You will then email and record these reports on excel. You will follow up each report until paid and again update the reports on excel...

  • Fixed Price Project
  • Max $300
  • 1 year, 3 months left

Job Details

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