Excel functions Or VBA?

[SSolano]

User has 2 worksheets.
User enters a value in worksheet 1 and the value is
automatically entered on a different cell in worksheet 2

User wants to be able to
Enter a value in sheet 1 that is entered on sheet 2 in the
same cell all the time, but also places the previous
contents in the cell below each time. Retaining all
previous values entered in sheet 1.

Is this doable without VBA?

 

[Frank Kabel]

Hi
not quite sure what you mean with 'retaining the previous values'. If
you want to store the old values you need VBA to achieve this. For just
linking cells you could simply enter something like the following in
sheet2:
='sheet1'!A1

 

[Harlan Grove]

...
...

Is this doable without VBA?

No, not possible without VBA.

 

[Don Guillett]

right click on sheet tab of source sheet>view code>copy/paste this.
Now when you change cell a2 on that sheet, col a on sheet12 will have your
entry.

Private Sub Worksheet_change(ByVal Target As Range)
If Target.address <> "$A$2" Then Exit Sub
With Sheets("sheet12").Range("a1")
..Rows.Insert
..Offset(-1) = Target
End With
End Sub