How to move up/down multiple rows?

Macro needed for deleting rows less then 5?

• Hi everybody I’m looking for a macro that would remove complete rows (not just delete the numbers) that have less than 5 cells because the rest of the rows are empty. Remove the entire row so the remaining rows (that have more than 5 cells with numbers) move up. Deleting only complete rows not cells. Skipping the rows with more than 5 cells for the entire worksheet . Also remove rows that are completely empty without effecting the surrounding formulas Because there is a lot of empty space between them. So I can make the rows in the worksheet more compact . Is this possible? If anyone can help. thank you

• Answer:

  Yes, it's possible. Everything you can do by hand can be done with Macro (and more), you just need to find a way to do it. You will need to write some VB macro (macro with complex conditional cannot be done simply with recording; though you can use the macro record function to leverage learning the VBA layer)