I need to delete all rows with data in column a in specific sheet in another workbook. I am currently sending information from 1 sheet to another sheet in a different workbook. When I send information I sometimes have less than the original. When I send the new information it just pastes over the existing and if the new is less than the original, the remaining original information stays. I have the vba for sending the information over working correctly I just need to remove all content from the destination sheet before I send it. Is there a way to do this?