VBA conditional copy and paste into another WB

[JyothiGrace]

I'm trying to call a code from "VBA Code Runner - Excel Forum" wb......but it doesn't seem to be working.

Note: I am very new to VBA so please provide a detailed explanation so I can adequately apply to my other wbs....thank you!


In "Coaching Report - Dest - Excel Forum.xlsm" wb, "Mission Control" ws, cell "B3", there is a conditional value......in this case "Kendal Gholston".

If in "Coaching Report - Copy - Excel Forum.xlsm" wb, "Full Append" ws, column "D" = "Kendal Gholston" (B3 of "Mission Control"), then I would like to copy those rows and paste/replace into "Coaching Report - Dest - Excel Forum.xlsm" wb, "Mission Control" ws, column "BI" (ignoring header).