Excel Macro Development.
The macro(s) required for this project will "clean up" online advertising media plans. Basically, this macro will move data from a client provided sheet (variable format) to a standardized sheet.
Some functions required include removing special characters from sheets; moving cell contents from one sheet to another; and, comparison/validation of two sheets.
## Deliverables
Overview: Online advertising agencies use Excel spreadsheets to create media plans. These sheets are non-standard. The overall goal of this suite of macros is to clean up a client provided sheet in a way that our internal system can read it for a batch upload. In addition, we need the ability to compare information on two sheets to ensure it is the same.
This project may consist of one or more macros depending on the developer's approach. Following is a basic outline of requirements.
Details attached.