Excel table into Powerpoint

D

Dawn

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!
 
B

Brian Reilly, MVP

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
 
Top