numbering records on multiple sheets.

[Guest]

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

 

[Guest]

Is the system assigning a number to them as they come in? is it already
there? or are you adding it yourself? Does the data need to be on seperate
sheets? If they are already there and sheet doesn't matter, you could
straighten them up with a lookup or program an interface to search for that
particular record number.

 

[Guest]

Thanks for the quick response. There isn't a system for numbering them as
they come in, so the specific number doesn't matter (it just needs to be the
next number) - the user was trying to number them and found he kept adding it
under a number that was used (ie- there are actually 158 records - so the
next should be 159, but he didn't see the 158th on one of the sheets so he
added the next one under 158 again.) He wants things seperated by sheets
also.

Hope that helps to clarify things