sobrien1234
Board Regular
- Joined
- May 10, 2016
- Messages
- 164
- Office Version
-
- 365
- Platform
-
- Windows
I have a sheet with hundreds of rows of data but there are a lot of blank lines so it makes autofilter redundant. I want to write a formula/macro so that in sheet2 it compresses and deletes all the bank rows in sheet1.