Hi,

I have a worksheet in excel and column A can have the value 'Yes' or 'No'
I want to copy the excel to powerpoint (using paste special, paste link, no
problems)
However, On 1 slide the rows from excel where the value in column A was
'yes', and on a second slide, the rows where column A was 'No'.
I want to see values which are altered in excel to be reflected in powerpoint.
Im not sure how to achieve this.
filtering doesnt work, I thought about having those rows with yes
automatically copy to another excel sheet and then copy this new sheet to
powerpoint. However, not sure how to copy the rows to another sheet.
Can anyone help? Can i achieve this without the use of macros and only using
excel functions?