So I've figured most of the report out and managed to add a small VBA code to save the file name as the "report title_date". I'm still facing challenges in working with the detailed findings sections. I've done the following now:
1. Settled on the final format of the detailed findings sections and kept all elements with different formatting as separate text boxes (in both excel and powerpoint)
2. Grouped the components of each finding together (i.e. Finding 1, Summary 1 and details grouped and so on..)
3. In the excel, in addition to formatting each element in keeping it in separate cell, I've also removed the bullets. Trying to figure out a way to bring back the bullets after pasting the text from excel to powerpoint.
4. Can't figure how the code will now work, since the text is not in one cell anymore.
I've attached the updated ppt (template and final outcome) and the fresh excel I've created. Since all findings are now separate text boxes (as opposed to a single rectangle earlier) I had to select and distribute them vertically. I suppose that could be possible via a macro as well (I'm trying that as I write this :-))
Have I complicated this too much?
Reply With Quote