Dependants

[Phil]

Is it possible that when I press ENTER the cursor is moved to a
dependant cell.

For instance, when I enter data in B26:G26 the results in K15:O15
change accordingly.
What I want is that after input into G26 the cursor moves to K15.

Hope you can understand.

Thanks

 

[RagDyeR]

Try this:

Select K15 to O15,
Hold down <Ctrl>,
An select B26 to G26.

Now, keep hitting <Enter>, and see what happens.

Is this good enough for you?

If it is, you can assign this a name, and re-use it, without having to
re-create it.

After you've selected B26:G26, and while all the cells are still selected,
after you release <Ctrl>, click in the name box and type in a short name,
such as "entr" (no quotes), then hit <Enter>.

Now, the next time you need to do this, simply expand the name box and click
on "entr", and you're all set to go.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Is it possible that when I press ENTER the cursor is moved to a
dependant cell.

For instance, when I enter data in B26:G26 the results in K15:O15
change accordingly.
What I want is that after input into G26 the cursor moves to K15.

Hope you can understand.

Thanks

 

[Phil]

It does the job thanks.
I now have B26:G26 linked to K15:O15. This needs to be carried on down
the sheet so each row is linked i.e 27 to 16, 28 to 17 etc. Is there a
"shorthand way" to do it as the current last row is 313 and that's a
lot of mouse work.

 

[Ragdyer]

I think you'll need code to automate this.