W Toku

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: 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

O pracodawcy:
( 2 ocen ) Spring, United States

Numer ID Projektu: #11752357

Przyznane 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 średnią kwotę w wysokości $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 Ocen)