hey guys!, so i was having trouble figuring out a formula in vba which copies a whole row to a different sheet.

for example, I have a list of names and data in a sheet called "data" what I want it to do is

1.) check the names in column 4 against data in column 4 of a different sheet called "yesterday"
2.) if the name is there, insert a blank row under the row in "data" and then copy the whole row with the name in it from "yesterday" into that blank row
3.) if the name isn't there, then I want to still add a blank row, but I want to blacken it out.

maybe there's a better way to do this, I am open to suggestions. I have a sample outcome if attaching that helps. Thanks!