How to ceate formula for cursor to tab cell vs, the next cell down

I would love to be able to write a formula that instructs the cursor, after data entered in one cell: say i9, move right in a tab fashion to j9, instead on a downward action to i10. Can that be done?

You can set this in Options -> "After Pressing Enter, move Selection": default is down but can be set to Right.

This applies to the entire spread sheet? How can you designate certain columns/row within a worksheet? For instance like the entire column of I moves the cursor to J only. I can always take your suggestion, and enact the move right when needed?

you need to use a macro


The following macro moves selects cell in column K whenever a single cell in column J is changed

'These instructions pre typed & are worded to cater for the novice programmer
'To install macro to correct location

'Copy this macro
'GoTo Excel
'Select sheet this is to appy to
'Right Click on Sheet Name Tab > select View Code
'Paste macro into the Worksheet Module displayed

Please Login or Register  to view this content.

Thank you for this, I copied this as you suggested on a blank excel sheet to test it, worked perfectly-then I tried to add this macro to the worksheet I intended to use this Macro on, received this error
Amiguous_Name change detected. By adding this Macro, it deactivated another Macro I have written to this spread sheet. It has the same name configuration as the Macro you provided-
I believe the Macro has to have a different name set?? The spread sheet has mutiple worksheet names-they are Feb wk1, Feb wk2, Feb wk3, Feb wk4 . . .What must I change so the two macros can coexist?
see attachment in a print screen copied into word so you can see the VB code that way-sorry didn't know I was doing something wrong.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Please follow following steps

1. Click Tools>Options from the toolbar
2.Select Edit tab from the options dialog box
3.Put a check mark on Move selection after enter
4.From the adjacent drop down list select Direction : Right

Now you get it

Have a nice time


Chris

Chris,

Please read the thread in full prior to posting... your suggestion has already been discussed (in the very first response) moreover the OP has stipulated certain criteria which necessitates VBA as outlined by Mudraker.

gmaz2

You can only have 1 macro of the same name in each module

The picture youenclosed shows you have 2 Worksheet_Change macros in the same module. This is the reason for the Amiguous_Name change detected message

The code from the 2 macros will need to be merged into the 1 macro.

Please post a copy of your 1st Worksheet_Change macro code - not a picture of it.

gmaz2

Sorry for the delay in replyiing.

Whilst I was submitting a reply yesterday I had a system crash & have only just realized me reply did not get posted


I have merged the 2 macro codes into this 1 macro

Please Login or Register  to view this content.

P.S
When posting code you will find it quicker & easier for everyone if you post the code within you message.
To post your code so that it is wrapped click on the # icon in the text formating window.
this will add
[co de][/co de] - without the space in the word code
to your message with the cursor inbetween the ][ brackets, paste your code where the cursor is.
When you submit your message the code will show up as wrapped in a window like my code is above