How to log daily data into a descending column

[KayZee08]

I have a spreadsheet that I am using for budgeting and I want to be able to track my savings by logging data from one cell.

If cell A1 represented my savings I want that copied to B1 then the next day when A1 changes the new value would be copied to B2 and so on.

Any way that I have tried so far B1 always gets overwritten when the new value comes along.

Thanks for your help!!

KayZee08

 

[Matty]

Welcome to MrExcel.

What triggers A1 to be changed? What is the value in this cell being fed from?

Matty

 

[KayZee08]

I found a macro for a crude version of what i was wanting but the only problem is that A1 is a sum of 3 other cells (chequing account, etc) and therefore changes when any of the other cells change, and the macro i found only works if A1 is manually changed. Instead of running daily.

The Macro I am currently using is :

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" Then Sheets("Budget Forecast").Range("B" & Rows.Count).End(xlUp).Offset(1) = Target.Value
End Sub