VB to copy rows from 1 sheet to another sheet

Hi All,

Been a few years since I posted here. I have zero experience with VB Macros. I need to copy a row (A2-H2) sheet "Master" to sheet "Spanish" if cell D2="Spanish", however I don't want cell D2 to copy over to sheet "Spanish". If cell D2 does not equal "Spanish", then I do not want any of the row to be copied over from "Master" to "Spanish". I have browsed this section, but I'm having a hard time understanding the coding to make this happen. Attached is the workbook for this project. Any help and education you are willing to provide would be most appreciated. Thank you.

Do you want to press a button or have it happen immediately on entering Spanish in D2

Immediately...This code in master sheet Module
When "Spanish" is entered into [D2], [A2:H2] excluding [D2] will be copied...

Please Login or Register  to view this content.

Why only row 2 by the way?

Thought so...

Edit....Forgot most important snippet in red...

Please Login or Register  to view this content.

..........................
=THANKS.gif