Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 45
Default Automatically move cursor when cell value changes

Using Excel 2003

I have 5 groups of 2 columns with 50 rows for each group of columns. I am
using an electronic device to input values into the cells. I have excel set
to move the cursor right after entering data.

What I want to do is when I am in the second column in a group and I enter
the data, I want the cursor to auto move back to the 2nd row in the 1st
column in that group.

For example

A b E F I J
1
2
3

When the data is entered into b1, I want the cursor to go to A2. when I
enter the data into b2, I want the cursor to move to A3 and so on down to row
50.

I would like to do this for each group of columns, i.e AB EF IJ, etc.

I have somewhat figured out how do do this, but it would take a lot of lines
of code.

Is there anyway I can do this fairly easily?

Thanks for your help

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hit enter in cell & move text down in cell, not go to cell below. raoul_duke Excel Worksheet Functions 4 April 2nd 23 08:37 PM
Cell References [email protected] Excel Discussion (Misc queries) 2 November 15th 06 11:37 PM
Using an offset formula for the reference in a relative reference Cuda Excel Worksheet Functions 6 November 15th 06 05:12 PM
How to Automatically Move Cell datato adjacent cell.. cardingtr Excel Discussion (Misc queries) 1 October 17th 05 03:59 AM
Move automatically to a cell Box666 Excel Discussion (Misc queries) 2 October 15th 05 10:34 AM


All times are GMT +1. The time now is 04:14 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"