I am looking for a code which can filter data and then paste in another sheet called "FTEs"
Basically we have multiple weeks data in one sheet, so what we need is we will select a week in Summary sheet and code will go to Data sheet and filter that particular data in Col.D and serach for all "Yes" and then paste in FTEs sheet.
[FONT="Calibri"]For example…if I select week 20 in summary tab then it should display only week 20 data in FTEs tab.
Attaching the sheet as well.
thanks for taking time out for this.[/FONT]