Thread
:
How do I make the cursor move down 8 cells each time i press enter
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
Candys Kisses
external usenet poster
Posts: 3
How do I make the cursor move down 8 cells each time i press e
Fab, that sorted things out! Thank you so much!
"Don Guillett" wrote:
Right click sheet tabview codeinsert this. Will change when you enter
something in a cell.
Private Sub Worksheet_Change(ByVal Target As Range)
if target.column<3 then exit sub
Target.Offset(8).Select
End Sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Candys Kisses" wrote in message
...
I am entering a whole load of data into Excel and need to jump down 8 cells
each time I press enter.
So I start in c2 and need to jump to c10, c18, c26 etc... up to c82
Then I start in c3 and on to c11,c19,c27 etc... then c4,c5 etc
Then I move on to d2 and enter the 89 lines of data jumping down 8 cells
each time.
An then onto e2, f2, g2 etc
Any easy way to just make the cursor move down 8 cells each time i press
enter?
Thanks!
Reply With Quote
Candys Kisses
View Public Profile
Find all posts by Candys Kisses