Excel functions Or VBA?

  • Thread starter Thread starter SSolano
  • Start date Start date
S

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?
 
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
 
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
 
Back
Top