"Shannan" wrote in message
...
Would that not make all the cells from B1 to B10 repeat? I only want B1 to
repeat.

Indeed it will - I assumed they might be blanks at present.

However, to overcome this, insert a temporary extra column and set it up as
per my original post. Then select the whole column, copy, select the
original column B and and use Edit, paste special, ticking the box for 'skip
blanks'. This will paste only the necessary text or formulae into your
original column. Finally delete the temporary extra column.

Hope this helps,

V