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

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

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

Look he

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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

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

hi,

A couple of methods of achieving that are here

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

Mike

"Craneman" wrote:

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