tommy1234
01-16-2018, 10:12 AM
Hello
I have a monthly presentation that contains at least 90 slides which takes me 3-4 days of work :banghead:
I would like to automate this process.
The presentation is based on data from 3 folders for each project (i have at least 30 projects)
1. Operational data folder.
2. Budget folder.
3. Ms- Project folder.
I would like to merge the data in the following way :
1.open "Operational data folder" open project x and copy a range of cells (which is always the same) and paste it as a picture to my presentation with headline from a row in the excel file.
add new slide the copy data from specific rows in my excel and paste it into 2 text place holders in my slide.
2.open "Budget folder" open project x and copy a range of cells (which is always the same) and paste it as a picture to my presentation with headline from a row in the excel file.
3.open "Ms- Project folder" open project x and copy the the schedule and paste it as a picture to my presentation with headline as file name.
Thanks a lot
I have a monthly presentation that contains at least 90 slides which takes me 3-4 days of work :banghead:
I would like to automate this process.
The presentation is based on data from 3 folders for each project (i have at least 30 projects)
1. Operational data folder.
2. Budget folder.
3. Ms- Project folder.
I would like to merge the data in the following way :
1.open "Operational data folder" open project x and copy a range of cells (which is always the same) and paste it as a picture to my presentation with headline from a row in the excel file.
add new slide the copy data from specific rows in my excel and paste it into 2 text place holders in my slide.
2.open "Budget folder" open project x and copy a range of cells (which is always the same) and paste it as a picture to my presentation with headline from a row in the excel file.
3.open "Ms- Project folder" open project x and copy the the schedule and paste it as a picture to my presentation with headline as file name.
Thanks a lot