Hi All,
I'm not sure if what I need to do is possible, I don't have much experience
with excel, but I do have a bit of Access knowledge -- problem is I need this
project in Excel.

My excel document is tracking records, but there are multiple sheets
depending on who owns that record/file. What I am trying to do is have a
column on each sheet (column A) that is numbered - BUT the numbering system
needs to go over all the sheets. So record one could be on sheet one but
record two could be on sheet two. The numbering isn't associated to the
record at all -- it is basically the order that the records were data
entered. I'm trying to figure out a way to do this so everytime the user adds
a record they don't have to look through each sheet to find what the last one
was, but maybe have a quick key or something that they could hit - to fill in
what ever the "next number" would be.

If anyone has any ideas I would love to hear them as I don't even know where
to start with this. I don't mind VBA programming - as I do with Access - but
I haven't done any with excel. I know this would probably be easier with
Access but the user is insisting excel....

Thanks a lot