Previous Topic Next Topic

EXCEL

Closed
DUMBBRAIN70 - Jun 30, 2009 at 03:47 PM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jun 30, 2009 at 08:35 PM
Hello,
IS THERE A WAY TO FILL IN A BOX, AND HAVE IT AUTO FILL ABOVE IN ANOTHER BOX,
AND THEN WHEN I GO IN AGAIN AND FILL IN THE FIST BOX LIKE LAST TIME, IT AUTO FILLS THE NEXT LINE, BECAUS THE FIRST LINE WAS FILLED IN LAST TIME.. i AM TRYING TO KEEP A HISTORY OF ENTRIES.

1 reply

Answer 1 / 1
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Jun 30, 2009 at 08:35 PM
suppose the sheet name is sheet1
the cell where you enter the data is A1
the entris in A1 are to be archived in column C

In that case try this

right click the sheet tab of sheet 1 and click view code
in the resulting window copy this event code.

[code]
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address <> "$A$1" Then Exit Sub
Target.Copy Cells(Rows.Count, "c").End(xlUp).Offset(1, 0)
application.cutcopymode=false
End Sub
[/code]


now as you go on entering the numbers (or strings) in A1 all will be archived in column C.
modify the code to suity you.
0