AHUB Customer Proposal VBA script

Objective: The objective of this project is to reduce administrative time and labor when populating customized customer-facing proposal decks by automating the process. Process Overview (See attached PDF for details): Either run from an Excel workbook or allow user to select Excel workbook: 1. Request user select a specific “base” PowerPoint 2. Request user select a target save location 3. For each row in selected Excel tab: a) Copy and transpose paste a set of numbers from one tab to another b) Copy information from the second tab and paste to a specific location in the PowerPoint deck c) Using information from a cell in the current Excel row, update several text placeholders found within text boxes on different PowerPoint slides d) Using information from cells in the current Excel row, update an embedded bar graph on multiple PowerPoint slides 4. Save the workbook with a specified naming convention Please see attached PDF for detailed description of what we need the code to do. We would like a finished product by Monday the 5th of June at the latest. The team is available for questions and to review code from 9AM to 4PM US Pacific Time