En curso

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

Habilidades: Excel, Microsoft, Visual Basic

Ver más: 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

Información del empleador:
( 2 comentarios ) Spring, United States

ID de proyecto: #11752357

Adjudicado a:


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 Más

$30 USD en 1 día
(67 comentarios)

2 los freelancers están ofertando un promedio de $50 para este trabajo.


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 Más

$70 USD en 3 días
(133 comentarios)