Hello all--

I'll try to descibe what I am trying to do clearly.

If I have numbers in cells A1:A5, I want to put new data in cell A6, hit the enter button, and have all of Row 1 be deleted automatically, so I still have only five rows.

Can this be done with functions or do I have to learn macros?

Thanks in advance.