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