Search range and copy cells to sheet2 if, if statement is true

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.

Thanks JBeaucaire.

I'm looking to add VBA to a macro button on Sheet2 so when I click it the information from Sheet1 would populate over. When I send out the report, Sheet1 will be veryhidden so only Sheet 2 will be displayed.

I've never dealt with strings before or ranges in VBA so this is the challenge that I am facing.

I'll give it a try AlvaroSiza. Thanks for the quick reply!

You too Trebor76! I'll let you all know how it goes shortly.

Thank you so much AlvaroSiza! You're code worked wonder. Thank you too Trebor76, the help is much appreciated! Have a wonderful night

A further question AlvaroSiza, if I would also like to add Store(C2:C100) along with Name(A2:100) how would I incorporate that into the code?

Worked great. Thank you Robert!