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

DisplayData_2007-09-04.ppt (293.5 KB, 10 views)

After long hours and much caffine consumed I have found the coding need to nearly complete this project. I have one other issue, but I will ofcourse post that in a new thread.

Thank you.