excel - Copy & Paste VB -

i new world of vb copy data 1 tabs on spreadsheet called ilog , past tab on same spredshhet on tab called journal.

when data pasted new tab i'd filter blanks ommited able vb code automatically.

any appreciated

i not asking, following code copy data range on sheet llog , paste in journal. loop through , delete cells blank.

sub test()  dim rng range  set rng = worksheets("llog").range("a1:a8")  rng.copy  set rng = worksheets("journal").range("a1:a8")  rng.pastespecial   each c in range("a1:a8")     if c.value = ""         c.delete     end if  next c  set rng = nothing end sub