Excel 2007 : Cursor Movement on Return

[KERNELJEFF]

I want my cursor to move from A1 to C1 after my first entry and then from C1 to A2 and so on. Can anyone tell me how to make this happen? Your help would be greatly appreciated.

Thanks,

Jeff

[dilipandey]

Hi Jeff,

You can use something like:-

Please Login or Register  to view this content.

Regards,
DILIPandey

<click on below 'star' if this helps>

[KERNELJEFF]

DILIP,

Not sure how to do that? I tried typing it in the cell but that didn't work?

Thanks,

Jeff

[dilipandey]

Hi Jeff,

Please upload the sample file.
Click on Go Advanced on the right side of reply section and the look for paper clip on the menu icons.

Regards,
DILIPandey

<click on below 'star' if this helps>

[KERNELJEFF]

Sorry but I can't find the sample file.........I clicked the star to quick

[dilipandey]

Hi Jeff,

By sample file, I am referring the file on which you are going to work but please replace the original data with some dummy results for confidentaility purpose. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

[KERNELJEFF]

cursor test.xls Here you go............

[KERNELJEFF]

This also relates to How to assign a macro to a cell.

[nlm]

Please find attached sheet and see if it works for you?

nlm
--

Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little scale)

[KERNELJEFF]

Thanks nlm! Unfotunatly this worded only in column C on your sheet but that's ok. I'm going to close this thread but would appreciate if you look at the other one I have going regarding "How to Sign a Macro to a Cell.

Thanks again.

[nlm]

It is preferable to have single post for single question!

Now to your question of assigning macro to a cell. You can assign macro to individual cell through code that I sent in attached file. The way you want can only be done through VBA code:

Please Login or Register  to view this content.

nlm.

[dilipandey]

Hi Jeff,

I could'nt look into this as I was litte occupied.
I hope the solution provided by nlm helped you. Thanks to nlm. Cheers

Regards,
DILIPandey

<click on below 'star' if this helps>