How do I have it select the non empty cells in range a1:D99999 and then export only the non empty cells to a separate worksheet?
Sorry, i am not a strong programmer