Here is my situation: I capture client information and create tables and charts in excel. I then paste as links this information into a powerpoint template (about 80 pages) to create client presentations. Tables, charts and legends almost always go in the same place. However, every time I make a presentation, it's as if I have to do it from start. I also end up typing a bunch of client information (names, ages, etc.) into text boxes in powerpoint.
Issue: Is it possible to automatically create my powerpoint presentation from excel without copying and pasting 20 something tables and charts? This is a repetitive process which should be programmable.
Another (related) issue I have is typing in repeating data from excel (e.g., client information such as names and ages) into text boxes in powerpoint. I would be great if powerpoint looked up this info in the excel file and filled out everything automatically.
I can't be the only one with this problem, but I've literally spent hours trying to figure out a solution. I would be very appreciative for any suggestions.
Thanks,
Frank
Bookmarks