Goodnight everyone,

I am working on a project and am just beginning to use VBA and am asking for some help.

I would like to copy from Sheet1 only the Name(Range A2:A100) into a new sheet, Sheet2, if the Recommendation(D2:D100) on Sheet1 is equal to "Y". If the recommendation is "N" then do not copy the Name. The data stops at row 101.

Therefore,
If Sheet1 cells of range "D2:D100" match if statement "Y"
then
Copy matching Sheet1 cells of range "A2:A100" to Sheet2.

The copied information should populate in Sheet2 starting at A2 then continue to the next row below and so-forth.

If any more information is needed I'll be glad to provide some,

Thanks everyone.