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