Hi there,

I was hoping someone might be able to help/

I have a line of data (say from B6 - S6) in cell S6, when i put in the word 'complete' i want the whole line of data to move to say line 34 - clearing line B6

Could anyone help re the above?

Thanks

Matt