Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-27-2013, 08:39 PM
bremen22 bremen22 is offline [Excel 2007] Building Power Point Slides from data in an Excel Table Windows 7 64bit [Excel 2007] Building Power Point Slides from data in an Excel Table Office 2007
Advanced Beginner
[Excel 2007] Building Power Point Slides from data in an Excel Table
 
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
  #2  
Old 08-07-2013, 11:01 AM
bremen22 bremen22 is offline [Excel 2007] Building Power Point Slides from data in an Excel Table Windows 7 64bit [Excel 2007] Building Power Point Slides from data in an Excel Table Office 2007
Advanced Beginner
[Excel 2007] Building Power Point Slides from data in an Excel Table
 
Join Date: Jul 2013
Posts: 44
bremen22 is on a distinguished road
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Attach a Excel file with Power point gmalpani Office 0 11-27-2011 03:11 AM
Sort Table in Power Point over multple pages nwong1288 PowerPoint 0 11-10-2011 02:29 PM
Microsoft Power Point 2004 to Office Power Point 2007 chuff PowerPoint 0 03-20-2011 01:23 PM
Info from excel spreadsheet to Power point anyquist Office 0 01-31-2011 12:29 PM
[Excel 2007] Building Power Point Slides from data in an Excel Table inserting power point slides into Word MastanehJD Drawing and Graphics 6 11-08-2009 01:24 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:14 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft