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.
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.
