[ezertuche]

Hello. I have a newsletter in my company in which I publish, among other things, people's birthdays.

When I first started with my newsletter, I had a huge birthday list organized by date and I would scroll down to the day's date and copy-paste the info onto powerpoint.

To make my life easier, I used an array formula in another sheet to make a table that shows today's birthdays, and is automatically updated every day. I link this table onto Powerpoint using Paste Special > Paste Link.

However, my birthday table is 20 rows deep, and the birthday list is always variable in depth, meaning that every day there are a different number of birthdays, so most of the time, my table shows empty rows.

My question is: Is there a way to tell Powerpoint to show a given number of rows?

Another way that I can think of is that I can (manually) HIDE rows in Excel and they are automatically shown hidden. Is there a way to automatically hide the number of empty rows in Excel, so that they are shown hidden in Powerpoint?

I'm familiar with Excel and I'm not computer illiterate, but I don't know a single bit of coding or very advanced stuff either.

Please help!

Eduardo