Not clear what you mean by "reference numbers". What should they refer to and how?

But do look he

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Pasty" wrote in message ...
| Is it possible to get excel to automatically generate reference numbers for
| different actions?