Find and move rows with empty Cell [Closed]

Report
-
Posts
124
Registration date
Tuesday November 18, 2008
Status
Member
Last seen
February 2, 2010
-
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

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
124
Registration date
Tuesday November 18, 2008
Status
Member
Last seen
February 2, 2010
33
Or there is another way, right click on the number of the row and cut it to paste in your other sheet...

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!