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
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 information.
$30 USD en 1 día
5,0 (67 comentarios)
5,1
5,1
2 freelancers están ofertando un promedio de $50 USD por 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 regards