Find and move rows with empty Cell

Closed
Nav - Jul 20, 2009 at 08:50 AM
jenni.g
Posts
124
Registration date
Tuesday November 18, 2008
Status
Member
Last seen
February 2, 2010
- Jul 21, 2009 at 12:40 AM
Hello,

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.

Thanks in advance for your time and suggestion.

Regards,
Naveen

2 replies

Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Jul 20, 2009 at 11:07 PM
Hello Nav

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
1
jenni.g
Posts
124
Registration date
Tuesday November 18, 2008
Status
Member
Last seen
February 2, 2010
33
Jul 21, 2009 at 12:40 AM
Or there is another way, right click on the number of the row and cut it to paste in your other sheet...
0