Excel Macro To Clean Up Raw Data

This project was successfully completed by vlayausa for $30 USD in a day.

Get free quotes for a project like this
Project Budget
$10 - $30 USD
Completed In
1 day
Total Bids
Project Description

Write a macro to clean up raw excel data. New excel data is received weekly. Number of rows changes weekly.

1) Add new sheets with reference table for decoding. User needs the ability to add-to and edit reference tables

2) Add new columns with lookup values from added sheets

3) Add new column to concatenated strings from other columns

4) Remove rows containing duplicate values for a given column based on a date value

Completed by:
Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online