I have attached an excel sheet which have 5 rows. 2 out of these 5 rows have empty cells(yellow marked). all i want is how to delete the rows which have empty cells....The output should look like the sheet2 data in attached file..
I have attached an excel sheet which have 5 rows. 2 out of these 5 rows have empty cells(yellow marked). all i want is how to delete the rows which have empty cells....The output should look like the sheet2 data in attached file..
Home > Find & Select > Go To Special on the Ribbon
select blank cells click ok
with cells selected right click choose delete entire row
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
thanx , its working fine,,,,,,,,,,,,.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks