Can I set up Excel sheet that auto increments a no. when opened

[Craneman]

I want to set up a spreadsheet with an auto incrementing form number in 1
cell. Is there a simple way to do this.

 

[Niek Otten]

Look here:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I want to set up a spreadsheet with an auto incrementing form number in 1
| cell. Is there a simple way to do this.

 

[Mike H]

hi,

A couple of methods of achieving that are here

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

Mike