I have a table (table4 on sheet1) that has a bunch of blank rows in it. Due to the rows getting filtered constantly, I can't just hide them as they will reappear every time I press show all. How do I go through a table ranging from A12-Vxxxx and copy every row with visible data into a table on a new sheet (sheet 2)?