I'm creating a spreadsheet that different users will use on a network of
computers, with there own "sign ons" as such (its at my place of work).

Different users will be adding dates for when items have been received. for
example cell a1 would be the date they have entered, and cell a2 would have
the name of the person who added the date, once they have entered the date in
a1, id like a2 to automatically enter the authors name.

so...
a1(date manually entered) a2(authors name, added auto once date has been
added)

Is there anyway to do this? I'm using Excel 2000

Many thanks,


John