I am new to excel with regards to advance programming.I have an excel with 1000s of records. It have approximately 20 columns. I need to loop through each of the rows and find out if any cell within a row is blank. If there are any, i need to cut the entire row and paste it into another sheet within the same workbook.
In the 21st column of row 1, type the formula =COUNTA(A1:A20) and copy it down to 1000 rows. The filter it to take all values not equal to 20. The press F5 >> Special >> select visible cells only >>Cut>>Paste