This solution is based on Current being on row 1 and the 1-Jan entries being
at row 3.

In B1, enter: =INDIRECT("B" & COUNT(B3:B1000)+2)
In C1, enter: =INDIRECT("C" & COUNT(C3:C1000)+2)
In D1, enter: =INDIRECT("D" & COUNT(D3:D1000)+2)
In E1, enter: =INDIRECT("E" & COUNT(E3:E1000)+2)

The end of the range, as :B1000 or :E1000 can be changed over time as your
list grows longer.

"hsfnwa" wrote:

The basic theory is everytime when I change the datecell under current, it
will automatic copy(link) to the next row instead override the same row
Does anyone know if excel has this ability to function this?

Your reply is highly appreciated~!

Current 100 40 200 150
Summary
1-Jan 100 40 200 150