In Progress

Excel Macro To Clean Up Raw Data

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

Skills: Excel, Microsoft, Visual Basic

See more: data transfer email excel, software write mq4, software write chip epson, useful software write book, software write web specs, software write edid, software write websites idea, software write book images, software write books, macro refresh excel data, processing raw data excel, software write protection, free software write book, excel lookup data internet, software write book, excel clean macro, software write technical manual

About the Employer:
( 2 reviews ) Spring, United States

Project ID: #11752357

Awarded to:

vlayausa

Hello, I am proficient with Excel and VBA and I would love to help you with this project. I checked your file and I am sure I can make a macro that will do what you require. Please contact me for more informatio More

$30 USD in 1 day
(67 Reviews)
5.1

2 freelancers are bidding on average $50 for this job

elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best rega More

$70 USD in 3 days
(133 Reviews)
6.4