Hi, sorry if title wrong, dont really know what to call this
Have the following code which excludes any rows where the critera given is met.
Do Until Range("A" & R).Value = ""
If Sheets("checkSmart").Range(QRiskRule1 &R).Value = "Annual Review" OrSheets("checkSmart").Range(QAdvType & R).Value...