I have form on an excel spreadsheet. I would like to fill out the cells in a particular order (A1-A7, then B1-B7, then A10-A17, then B10-B17, and so on). Enter always takes me to the next cell below. Tab always takes me to the next cell to the right. I have created a named range and put those cells in order but enter still always goes down and tab always goes right. I thought a named range would work. Any suggestions. I am not opposed to using VBA if anyone can point me in the right direction.

Thanks,

Jason