If there is "yes" in the cell then automatically copy that to another Sheet

[shifaag]

i'm not very good in excel and i'm using excel 2007.
I have create a master sheet name " Vaccine List 2014 " there are several data relating patient, I want to copy some data from master sheet If there is any 'yes' to another sheet Name " Vaccine List " there I have make a summary table named " Request from " . So If there is Any formula or VAB to do that.

I have Attach the orifinal file

[alansidman]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.