I'm attempting to consolidate data in an Excel Spreadsheet, automatically into a Word Document and PPT. I've attached three sample files.
1.) I know they must all go in the same folder to have the auto updates (without a path). I am hoping it doesn't have to reside on the desktop.
2.) I do not know if I need to store these as templates or just simply a doc (macro enabled?) and ppt (macro enabled)?
3.) From the sample, you will see that it starts with data in the spreadsheet and I've enclosed the identifiers as <NAME>
Any help in working through this sample is much appreciated.
B. Excel-Data.xlsm Excel-Data.xlsm