Hi all,
I've got a macro which shows all fields in a pivot table, and then takes the data and places it alphabetically in another sheet via a formula in the cells of the second sheet. What I would like to do is hide the blank cells (empty text " "). or at the very least move them to the bottom...