Hello -
I have a basic spreadsheet with the following information. Cells
A2:A11 contain basic number valus. Cell A1 is blank.

What I would like to accomplish is for a user to enter a value into
cell A1 and have that information replace the value in A2 and shift the
rest of the values in the column down. I only want to store 10 numbers
(ie A2:A11) at a time.

Can anyone provide me with the knowledge on how to accomplish this?

Thanks!