Extract a column data in different sheet

Mazhar Sayed - Dec 6, 2017 at 12:42 AM

I need help on the below

eg : I have a file with 2 sheets 1 Tracker , 2 DD2

In tracker I have lots of column but I want the first column to be pasted in DD2 sheet if in the tracker 4 column says Y.

How can I do this.

Please I need an urgent help