I am working on a Data Validation piece at the moment. The workbook will contain a column that has National Insurance number in and I am wanting the robot to select the rows where the NI number is missing and copy & Paste them onto another workbook. Instead of getting the robot to filter by blanks and copying the range I was wondering if any of you have done this another way?