Deleting Empty ROWS - Between 2 worksheets

[fundi]

I have AUTOMATICALLY Copied 3 COLUMNS from Worksheet 1 to Worksheet 2. Whatever I input in these 3 COLUMNS of Worksheet 1 , is copied into Worksheet 2.

PROBLEM-
There are LOTS OF EMPTY ROWS being created in the WORKSHEET 2.

Any solution please ?

 

[PaulF]

Turn your data into a table > CTRL-T (Yes to headers)



Date Tab >> Get Data from Table



Select Sales Date Pull Down and deselect 0



Close and Load



Done:



Takes about 10 seconds... (maybe )

Keep Calm and XL ON !!

 

[AlanSidman]

Or a VBA solution:

Option Explicit

Sub DelRows()
    Dim i As Long, lr As Long
    lr = Range("F" & Rows.Count).End(xlUp).Row
    For i = lr To 2 Step -1
        If Range("F" & i) = "" Then
            Range("F" & i).EntireRow.Delete
        End If
    Next i

End Sub

 

[fundi]

Turn your data into a table > CTRL-T (Yes to headers)

View attachment 60125

Date Tab >> Get Data from Table

View attachment 60127

Select Sales Date Pull Down and deselect 0

View attachment 60128

Close and Load

View attachment 60129

Done:

View attachment 60130

Takes about 10 seconds... (maybe )

Keep Calm and XL ON !!

Thank you sooo much ! :D

Btw, whats the advantage of creating a TABLE ?
I just figured, I can directly goto FILTER and un-select the items not needed...