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
 
Back
Top