If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
jump to new cell
I have a worksheet that is a few columns that are added
into totals at the bottom. There are 100 rows. Is there a way to make the active cell move to the top of the next column when they hit enter on the 100th cell. For example: when they enter a number in cell a100 it will automatically jump to cell b1 for the next entry instead of going down to a101? Thanks, |
#2
|
|||
|
|||
jump to new cell
Hi
If you select a range of cells (like A1:B100) then Excel will move between these cells only. HTH. Best wishes Harald skrev i melding ... I have a worksheet that is a few columns that are added into totals at the bottom. There are 100 rows. Is there a way to make the active cell move to the top of the next column when they hit enter on the 100th cell. For example: when they enter a number in cell a100 it will automatically jump to cell b1 for the next entry instead of going down to a101? Thanks, |
#3
|
|||
|
|||
jump to new cell
HI,
Try this - you put the 101st value in cell a101; it 'wraps' on each 100th row. jeff Private Sub Worksheet_Change(ByVal Target As Range) Dim lastrow As Long Dim lastcol As Integer If Intersect(Target, Me.Range("a101:a101")) Is Nothing Then Exit Sub lastcol = ActiveSheet.Cells("1", Columns.Count).End (xlToLeft).Column lastrow = ActiveSheet.Cells(Rows.Count, lastcol).End (xlUp).Row Application.EnableEvents = False If lastrow = 5 And lastcol 1 Then lastcol = lastcol + 1 lastrow = 1 Else lastrow = lastrow + 1 End If Cells(lastrow, lastcol) = Target.Value Target = "" Application.EnableEvents = True Range("A100").Select End Sub -----Original Message----- I have a worksheet that is a few columns that are added into totals at the bottom. There are 100 rows. Is there a way to make the active cell move to the top of the next column when they hit enter on the 100th cell. For example: when they enter a number in cell a100 it will automatically jump to cell b1 for the next entry instead of going down to a101? Thanks, . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
**Trying to use answer from another formula cell in another formula | KIMBERLY | Worksheet Functions | 1 | April 27th, 2004 06:22 PM |
How do do Concatenated Cell Values | Steve Arndt | Worksheet Functions | 3 | January 21st, 2004 05:34 PM |
Link or paste cells based on Date in cell | Ayanna | Worksheet Functions | 0 | December 16th, 2003 06:10 PM |
Finding cell references | Gary Thomson | Worksheet Functions | 0 | December 4th, 2003 12:08 PM |
Question on LOGIC ?? - PLEASE HELP | PM | Worksheet Functions | 17 | November 28th, 2003 09:13 AM |