Hi All,

I've just got to grips with the basics of VBA but I need your expertise with a particular code. Looking at the data below, I would like the code to be written so if the the answer is yes is Column D (contractor info) I want the entire row to be cut and added to sheet 2. Sheet 2 would have the same headings. there will be no blanks at all.

District Work Request Audit Result Contractor Info provided
21 39NGWS D4 yes
81 01MNRK D4 No
81 01MQQZ D5 No
81 01MSCF D7 Yes
12 37JZLW D8 Yes

I'd be grateful if someone could help me with this.

thanks in advance