Then do check the link I gave you
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
| Hi,
|
| What I was getting at was - it will be used on a risk register and I when
| people put in a new action i would like excel to automatically give it a new
| number, but I'm not entirely sure this is possible.
|
| "Niek Otten" wrote:
|
| > Not clear what you mean by "reference numbers". What should they refer to and how?
| >
| > But do look here:
| >
| >
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| >
| > | Is it possible to get excel to automatically generate reference numbers for
| > | different actions?
| >
| >
| >