Can anyone advise how i can autofill a column each time there is an occupied
cell down to the next occupied cell and carry on doing this to the end of the
column? I can obviuosly do it manually but is there a line i can put in a
macro to do this?

Thanks