Automate a macro and assign it to a sheet

Hi everyone,

I am quite new to this and I have been trying some things here and there.
I am now making a list of movie titles and I created sheets for each genre.

So let me explain a bit.

I have two sheets ;

1st sheet contains two columns; one for the movie titles and the other for the genres.
2nd sheet is my "Action" movies sheet where I want all the Action movies from the 1st sheet to appear.

My issue is that once I import movies from the 1st sheet, it creates blank rows in the 2nd.

I applied this :

Sub sbDelete_Rows_IF_Cell_Is_Blank()
Dim lRow As Long
Dim iCntr As Long
lRow = 20
For iCntr = lRow To 1 Step -1
If Trim(Cells(iCntr, 1)) = “” Then
Rows(iCntr).Delete
End If
Next
End Sub

and it works well, but I need to press F5 in my 2nd sheet each time I add an Action movie title to my 1st sheet.

So my question is : Is there a way to automate this macro so that each time I add a title it automatically deletes the blank rows ? Also do I need to assign it to my sheet if it was created there in the first place ?


Sorry if I was unclear english is not my primary language but don't hesitate to ask any questions.