Easiest way would be to add a macro that inserts one row at the top and then
deletes the last row. assign it to a button or whatever and you are ready to
go.


"today()" wrote:

> I have an excel sheet with several cells occupied by cerial numbers. I want
> to be able to advance all numbers one cell, when a new one is entered in the
> first cell. The number in the last cell needs to fall off the page as they
> advance to the end.
> Thanks
>