Hi All,

I have been given a big task to complete which you have all helped me out with enormously so far.

I have a spread sheet which is automatically populated from a user form. However, when completing the user form there could be anything from 1 line of data to 20 lines of data. I am being asked the question if when populated I can remove all of the blank lines from the spread sheet (These blank lines have a formula in but nothing returned)

Is this possible to do?

Thanks

Katie