View Single Post
 
Old 07-27-2013, 08:39 PM
bremen22 bremen22 is offline Windows 7 64bit Office 2007
Advanced Beginner
 
Join Date: Jul 2013
Posts: 44
bremen22 is on a distinguished road
Question

First let me start off by saying I am not a programmer. Most of what I have accomplished on this project so far has come from a lot of time spent on forums. That being said here is what I am trying to achieve....

On a monthly basis we generate a Power point presentation for upper management. Currently this presentation is created by hand, and I am trying to automate the process.

All of the data I need I am able to pull our of our Oracle database. In my workbook book I have three sheets. Each sheet has a unique query that pulls purchases by vendor for the previous month. The query, when refreshed, builds a table in Excel with the proper data. The number of rows generated will vary from month to month based on activity. The last step to my project is moving that data into the PowerPoint template I have created. The best way I can explain in plain English what I want done is this:

1) Look at sheet1.
2) Take however many rows you find there and transfer the data to the ppt template from slides 5-15.
3) Only place a maximum of 6 rows of data per slide.
4) Look at sheet2.
5) Take however many rows you find there and transfer the data to the ppt template from slides 16-25.
6) Only place a maximum of 6 rows of data per slide.
7) Look at sheet3.
8) Take however many rows you find there and transfer the data to the ppt template from slides 26-35.
9) Only place a maximum of 6 rows of data per slide.

Is this possible?

I have attached the file to that maybe you can figure out what does what.
Attached Files
File Type: ppt DisplayData_2007-09-04.ppt (293.5 KB, 8 views)
Reply With Quote