Excel table into Powerpoint

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table I have linked to a Powerpoint slide. However, it is for a top
10 list and sometimes there are less than 10 items. Is there a way to make
the update only include the rows that contain data for that week? So if I
update it one week and there are 10 rows of data, it would put all 10 in.
But, if I only have 6 rows one week, it would not show the 4 blank rows?

Thank you very much!
 
You'd want to use dynamic named ranges in Excel. Very powerful but not
intuitively obvious. Google on dynamic ranges Excel to do some
research.

Alternatively, a vba solution using .End(xlup) might be easier to
mangage and then copy and paste the range into PPT.

Brian Reilly, MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing multi-page table into PowerPoint slide 0
Selecting and deleting multiple table rows at the same time with V 5
Presenting Financial Data in More interesting ways 2
Powerpoint and Excel link problem 1
Excel 2007 objects paste linked into PowerPoint 2007, why doespowerPoint reopen the excel file for e 0
Embed an Excel Chart within a Powerpoint Presentation. 2
PowerPoint Row Selection Limit 1
Specify row height in powerpoint table 3

Back
Top