Hi all,

Honestly not sure how to phrase this problem (part of the reason googling isn't being that helpful) but I'll try my best! I'm helping a friend who isn't all that technical.

He has an Excel file and a PowerPoint file. I linked several Sheets into the PowerPoint such that updates to the Excel update the PowerPoint automatically.

However there is a flag on the some sheets called External, this is set to either Yes/No(for Internal). He's hoping for a way to filter the data going to the PowerPoint based on whether the flag is set to one or the other. The whole row would have to incorporated for each row that has a External = No (if producing Internal report) or External = Yes (if producing External report)

Is this possible? Maybe with a Macro? Or is it more of a PowerPoint problem?

I'm a programmer but I don't have extensive Excel or PowerPoint experience so the best option right now isn't clear to me.

Any approach that emulates this functionality would be much appreciated!
Even guidance would be great!

Thanks in advance!
Anakranox