I am new to Excel and am trying to create a Macro to delete empty rows. For example, I am trying to delete an entire row if nothing is populated in certain cells within that row (i.e. if nothing is in Column E).
I have attached a very simplified version of what I am trying to do. I have data in rows 2, 5, and 6, but now want to run a macro that will delete rows 3 and 4 (especially when I have hundreds of lines of data).
Please provide very basic instructions starting with how to set-up the Macro / Run the Macro.