VBA: Mediaplex Export Sheet to Columns Format
This excel macro automatically converts Mediaplex tags from the list that exports from Mediaplex into an excel-friendly multi-column list.
Simply drop your export into column A, install the macro below and run.
The “Final Sheet” tab that will break the Mediaplex tags into column by placement, tag type, and the tag itself. This project came about because Tim Conley sought a more efficient way to sort and manipulate Mediaplex tags and the ad server does not offer a way to export tags in Excel.
If you need to know how to implement this code please refer to my post on How To Install VBA Macros.
For some crazy reason the comment out “<!–” in the code below is removing half of the code/causing issues. Open the following .txt and use that code instead. If you know a solution, please leave a comment.
If this code has helped you, or you have additional modifications please leave a comment below.