See JE McGimsey's site for code.

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


Gord Dibben Excel MVP

On Sat, 22 Jan 2005 14:13:01 -0800, "mb" wrote:

How can I automatically enter invoice number and have it sequential as i open
the next template.