Hi,
I have a generic Excel invoice with columns and rows that are not always used for every single billing and I'm trying to tidy it up. For example, the invoice has a cell named "Description" and cells underneath it; however, sometimes, the description is not needed on the invoice and the cells under it are empty. I have managed to leftshift the empty cells, but I would like to delete the title cell as well if there is nothing under it. That is, the cell with "Description" should be deleted with all cells under it if they are empty. This goes for any other cells which have titles, but nothing underneath them.
I hope this is clear. I don't have much experience in Excel VBA (done some Word).
Thanks for all the input.
Leffe
Bookmarks