excel to powerpoint

C

confused

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?
 
V

Vacation's Over

Using limited complexity:

create two new tables that pull directly from the first table
filter one for yes
filter the other for no
post each new table to a page in power point
 
Top