Hello, I'm looking to enter data from a single "entry cell" (ex. A1) and have that data appear in a range of cells (ex. B1:B14) from the "most recent" entry descending down to "least recent", with the oldest/bottom cell (ex. B14) being replaced with data from the cell above it (ex. B13) as new data is entered (in the event when the range of cells is completely filled with data).

I'm also looking to get the "entry cell" to clear itself once data is entered as well, and for the current date of the entry to appear in the range C1:C14 alongside its corresponding data in Column B.

An example of what I'd like to do is enter data in A1, say "20", and have it appear in B1, (with the current date also appearing in C1). A1 then becomes empty for the next entry. I then enter "15" into A1. B1 then shows "15" (with its current date in C1), and B2 now shows "20" (with the corresponding date in C2), and this pattern continues until the range B1:B14 is filled with data. From this point, the pattern continues, only now B14 gets replaced with B13, in effect deleting the former value of B14.

My purpose for this to have a single data entry cell that can be used to produce a graph showing activity over the past 14 days (or instances), without having to manually alter data within B1:C14 everyday.

After looking from past threads which sort of relate to what I want to do, it seems that this requires vb code to be pasted into the worksheet. This is beyond my current level of understanding, so any help would be very appreciated. Thanks.