Hi Amber,

You can use either TAB or ENTER with Ashish's method. Enter is more
convient for typing, I would think.

HTH
Regards,
Howard

"Amber" wrote in message
...
I am looking for a formula to end a column say at A20 and then begin again
at
B1. Is there a formula for this. So when typing you don't have to click B1
everytime??
Thanks for your help.