Hi,
How can I fill a table in excel 2007 start from column "A" until column "E" and pushing enter every time after typing data then from column E it should jump to the next row to column A. Going on until row 3000 then jump back to A1.
I tried with this but it can handle just 320 lines and I would need 3000:
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Select Case Target.Address()
Case "$A$1'"
Range("$B$1").Select
Case "$B$1'"
Range("$C$1").Select
Case "$C$1'"
Range("$D$1").Select
Case "$D$1'"
Range("$E$1").Select
Case "$E$1'"
Range("$A$2").Select
...
End Select
End Sub
Thanks
GL
Bookmarks