Does anyone know how to set up a 'master' form that is pre-numbered, or auto advances with every use. Example: As the form is used, it is printed as form number 1000, next use 1001, 1002 and so on. Need it to automatically number it to avoid human error.

Currently using the form on one sheet, with a log on another. Have tried using macro's, functions, etc. Can't seem to find the right combo. All templates I have seen do not have auto numbering, so I have a feeling it is beyond excel's capabilities, but just in case I missed something (new to excel, former Lotus user, new job).

Using Excel 2002.

Thanks for your thoughts and/or ideas.