Date and time stamping multiple cells for multiple entries.

[Gerald]

I am using EXCEL to track various activities. How can I get multiple date
and time stamps to automatically fill? For example; Cell A2 is filled in
with data and cell G2 date and time stamps when cell A2 is completed. Then
when the next activity is entered in cell B2 the date and time is stamped in
H2.

[JE McGimpsey]

See

http://www.mcgimpsey.com/excel/timestamp.html


In article <93C72CAD-00B3-41EF-8458-25D1766A60DA@microsoft.com>,
Gerald <Gerald@discussions.microsoft.com> wrote:

> I am using EXCEL to track various activities. How can I get multiple date
> and time stamps to automatically fill? For example; Cell A2 is filled in
> with data and cell G2 date and time stamps when cell A2 is completed. Then
> when the next activity is entered in cell B2 the date and time is stamped in
> H2.