Well the worksheet and workbook events are inportant because you don't need a
button or something the user has to do to start the macro. The events are
generated based on what the user does. Like whenever the user clicks out of a
worksheet you can tell the worksheet to do whatever it is you want, or if a
user starts a new row it can automatically be colored a certain color, etc.

"Ed" wrote:

It sounds fine.
Thanks, Tom. Coming from you, that is very confidence-inspiring.
Well, at least for the concept - we'll see if I can make it work!

Are you intending this to be multi user - if so, DEFINITELY access.
Under NO circumstances share your workbook!
This will be for my use only. although I'd like someone else to be
able to work on it if I'm gone. This will not be a multiple-user file
inthe sense of many people opening and inputting all day long.

Are you familiar with VBA? If you NEED to do this on excel, even though like
you said Access would make your life a million times easiar. I would work
with Worksheet Events that can figure out what you are trying to do.
I need to know more info like how is the information is gathered, how it's
put in to excel, is it an import or does someone manually type it in?
I am familiar with VBA, although not greatly expert by any means. I
can usually hack something together to accompish the mission, quite
often with much help from the NG. For example, I don't see how
Worksheet Events come into play here, because I've rarely used them.
Yes, it must be done in Excel, and everything will be typed in
manually.

Ed