Jump to top of next column on Enter

Hello,

I have an area where I'm entering data. It is 12 columns x 40 rows. I'd like to enter data in the left column, and when I hit "Enter" at the bottom of one column, I'd like the next cell selected to be at the top of the next column.

Example: The last cell in the first column is B49. When I hit "Enter", I'd like it to jump to C10 which is the top of the next column.

This maybe should be in programming, but I thought maybe there was a way to create a custom "work area" where the active cells are selected only in that range...

Thanks for any help.

Jason

Ok, I just solved my own problem. I'm using this in the code for each worksheet.
This jumps to the next column when the cell below my last data entry is selected.

ie.: I enter data in B49 and then hit enter which selects B50. When B50 is selected, it jumps to the top of the next column.

Please Login or Register  to view this content.

It does what I'm looking for.

Thanks,

Jason