is there a way of inputing information and when you press enter send it to a
certain cell?

my problem is that I enter information (for example) in cell C15 then G15,
then P15, then I jump down all the way to D59

can anyone help me with this little task?....thanks

You could temporarily hide columns D to F and H to O to make it easier
to enter data across, and you could also hide rows 16 to 58. Unhide
them when finished.

Hope this helps.

Pete

On Apr 24, 4:04*pm, jcheko wrote:
is there a way of inputing information and when you press enter send it to a
certain cell?

my problem is that I enter information (for example) in cell C15 then G15,
then P15, then I jump down all the way to D59

can anyone help me with this little task?....thanks

Sounds like you want to jump from cell to cell as you enter data.

There are a few ways of using the Tab key to move through cells in the order you
wish.

See Bob Phillips' site for some of these.

http://www.xldynamic.com/source/xld.xlFAQ0008.html

There is another method using VBA with worksheet event code.

Post back if you want to try that.


Gord Dibben Excel MVP

On Thu, 24 Apr 2008 08:04:04 -0700, jcheko
wrote:

is there a way of inputing information and when you press enter send it to a
certain cell?

my problem is that I enter information (for example) in cell C15 then G15,
then P15, then I jump down all the way to D59

can anyone help me with this little task?....thanks

the page you sent sent me was awesome that is a good tip.

I would like to use the VBA so that I can create a userform were I can enter
the info, so that the info that was entered in the userform can put it in to
the cells I need the information in. thanks.

"Gord Dibben" wrote:

Sounds like you want to jump from cell to cell as you enter data.

There are a few ways of using the Tab key to move through cells in the order you
wish.

See Bob Phillips' site for some of these.

http://www.xldynamic.com/source/xld.xlFAQ0008.html

There is another method using VBA with worksheet event code.

Post back if you want to try that.


Gord Dibben Excel MVP

On Thu, 24 Apr 2008 08:04:04 -0700, jcheko
wrote:

is there a way of inputing information and when you press enter send it to a
certain cell?

my problem is that I enter information (for example) in cell C15 then G15,
then P15, then I jump down all the way to D59

can anyone help me with this little task?....thanks

If you want a UserForm to populate cells, that is a whole 'nother matter and
does not require any of the "jump-to" methods I referred to.

For basic userform creation see Debra Dalgleish's site.

http://www.contextures.on.ca/xlUserForm01.html


Gord

On Thu, 24 Apr 2008 09:42:07 -0700, jcheko
wrote:

the page you sent sent me was awesome that is a good tip.

I would like to use the VBA so that I can create a userform were I can enter
the info, so that the info that was entered in the userform can put it in to
the cells I need the information in. thanks.

"Gord Dibben" wrote:

Sounds like you want to jump from cell to cell as you enter data.

There are a few ways of using the Tab key to move through cells in the order you
wish.

See Bob Phillips' site for some of these.

http://www.xldynamic.com/source/xld.xlFAQ0008.html

There is another method using VBA with worksheet event code.

Post back if you want to try that.


Gord Dibben Excel MVP

On Thu, 24 Apr 2008 08:04:04 -0700, jcheko
wrote:

is there a way of inputing information and when you press enter send it to a
certain cell?

my problem is that I enter information (for example) in cell C15 then G15,
then P15, then I jump down all the way to D59

can anyone help me with this little task?....thanks

thanks for your help

"jcheko" wrote:

is there a way of inputing information and when you press enter send it to a
certain cell?

my problem is that I enter information (for example) in cell C15 then G15,
then P15, then I jump down all the way to D59

can anyone help me with this little task?....thanks