Roger Govier wrote in
:
Hi
In another column, say in D1 enter
=MAX(C:C)+1
This will always give you the next number you need to use.
Perhaps if you place your cursor in cell A2 and WindowsFreeze Panes,
then cell D1 will always be visible as you scroll down your list.
Regards
Roger Govier
perfect, thanks :-)
|