Hi People!
Sorry i'm very basic with macros, I have a vague idea but to be honest the last time I've done one was 8 years ago.
I think this might be simple, but I can't do it, so it would be really helpful if you guys can help me
I have a file with 2 sheets, one called "Recommendation Table" and the other "Close Out Plan"
So, I need to populate all the information from the "Recommendation Table" sheet into the "Close Out Plan" based on the value of the D Column of the "Recommendation Table" (if Column D=Critical or Essential, then I'd need to copy all the row, otherwise I need to check the next row).

Thanks in advance to everyone.
Miguel.