EXCEL

[Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
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

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
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.