Hi everyone,

What I am currently working on is developing a presentation for our sales reps to use for door to door solar panel installations.

Ideally, I want some kind of question list to pop up first, asking the sales rep for his/her name, company name, and contact info. Once entered, this will automatically populate certain portions of the powerpoint presentation, such as filling in the sales rep name on the intro letter, and company contact information at the top. As the prompt moves forward, the sales rep should be able to enter "roof square footage", total down payment for the plan, length of agreement, ect. All of this information would need to be put into a formula and spit out a final answer into the powerpoint automatically.



The way that I am currently working on involves using a VBA prompt in Excel, which will populate a data list, then have powerpoint call in that data list which will be shown during the presentation. Is there a better or more simple way to accomplish this? Unfortunately, the VBA script will not be able to be run on the iPad which is what a majority of the sales reps use.

Thank you!

Mike