Move to next colume after return....

**legendr34** · 12-01-2010, 06:59 PM

Hey guys, nice forum! I did a quick search, but was unable to find an answer

For example: I need a macro that starts at A1 and when I input data and press return, it will move to B1 and then I input data press return immediately it should go to A2 and repeat thus process for as long as I need.

It would wonderful if someone can help me out with this.

I bought a digital measuring caliper with USB and all it does is go to the next line after the button is pushed

Thanks!

**JBeaucaire** · 12-01-2010, 07:01 PM

This isn't a macro thing, it's a "plan ahead" thing.

1) Highlight a range of cells in A:B, like A2:B10

2) Type in the first highlighted cell

3) When you press ENTER, the cursor will go from A2 to B2, then from B2 to A3, etc, just like you want.

**legendr34** · 12-01-2010, 07:09 PM

Originally Posted by JBeaucaire

This isn't a macro thing, it's a "plan ahead" thing.

1) Highlight a range of cells in A:B, like A2:B10

2) Type in the first highlighted cell

3) When you press ENTER, the cursor will go from A2 to B2, then from B2 to A3, etc, just like you want.

Hi Jerry, thanks for the quick response

I tried what you said, however it doesn't go from A2 to B2 after the return, it keep down down the line and will go to B2 once it reach the bottom of the highlight

**JBeaucaire** · 12-02-2010, 10:59 AM

Check your Tools > Options > Edit and make sure the "Move selection after Enter" is set to the direction you want.

Or, by default, excel goes Down for ENTER but it goes to the Right for TAB.

**legendr34** · 12-02-2010, 05:44 PM

Originally Posted by JBeaucaire

Check your Tools > Options > Edit and make sure the "Move selection after Enter" is set to the direction you want.

Or, by default, excel goes Down for ENTER but it goes to the Right for TAB.

nice, thank you Jerry