code for the filerting and copy n pasting in another sheet

[Veeru]

Hi Folks,

I am looking for a code which gives me details from Data sheet as per Col. D...Code will filter "Yes" from Col. D and paste in another sheet called "FTEs" for week 18 and all this will be controlled from Smmarya.

Code should give data for that week which we select in Summay tab.

Attaching the shet as well.

thanks fo taking time out for this.