Hi,

I want a macro that will copy the contents of O1 in every row of column L until it reaches the word department in column A.
But then when it has stopped at the word department I want it to copy the contents of O2 in every row after that.

Sounds a bit complicated but can anyone help please?