Hi thank you very much for your quick reply I have to say a big sorry I have posted the question completely wrong
your answer is right but what is needed is data entered in a1,b1,c1,d1,e1,f1 then after the enter on f1 the curser moves to a2 then on reaching f2 press enter and auto move to a3 hope this makes sense. I did this with a macro a few years back but can't remember it sorry again and thanks.