ExcelBanter - how do I automatically advance data to next cell when overwritten

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - how do I automatically advance data to next cell when overwritten (https://www.excelbanter.com/excel-programming/343223-how-do-i-automatically-advance-data-next-cell-when-overwritten.html)

today()

how do I automatically advance data to next cell when overwritten

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

All times are GMT +1. The time now is 05:24 PM.