Auto-number in a column

[MaryS]

Hello,

I want to use Excel to do very simple database-like
recording and sorting of information. The people who will
need access to the info don't have Access - so that is
why we are using Excel.

Each row will contain one record of information. I would
like one column (or one field in the row) to be an auto-
numbered by Excel, but I don't know how to do this. Can
you help? Since the numbered cell will be a reference ID -
once it is assigned to a row I don't want it to change -
even if someone adds a row above it. Is that possible?

Thanks,
Mary

 

[Earl Kiosterud]

Mary,

I think the only reliable way to have this happen automatically is with a
macro, which we can write for you. This means users will have to enable
macros, and you'll have to be able to put in macros. Wanna?

 

[Guest]

Earl,

Thanks for your quick response and suggestion of a macro.
While I'm not macro-capable there are some programmers
here who I could ask for help. For now, in the interest
of "get it done and start using it" I think we'll just
type in the ref numbers. Thanks for for you help.

Mary