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

Umiejętności: Excel, Microsoft, Visual Basic

Zobacz więcej: home based data entry transfer data from hard copy to excel d14 eunos geylang paya lebar, excel macro to get data from website, excel macro to extract data from webpage, data entry from website to excel, zillow api data extract and save to excel, data transfer from email to excel, data entry from pdf to excel, software write mq4, software write chip epson, useful software write book, software write web specs, free software write user guide, software write edid, free software write company profile, software write websites idea, software write book images, software write books, export excel data project using macro, macro refresh excel data, processing raw data excel, software write protection, free software write book, excel lookup data internet, software write book, macro programming excel data input

O pracodawcy:
( 2 ocen ) Spring, United States

Numer ID Projektu: #11752357

Przyznany użytkownikowi:


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 Więcej

$30 USD w 1 dzień
(67 ocen)

2 freelancerów złożyło ofertę na kwotę $50 do tego projektu


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 Więcej

$70 USD w ciągu 3 dni
(133 Oceny)