MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Time Stamp


Posted by Kurt on May 15, 2001 6:59 AM

Is there a quick and easy way to have a time stamp inserted in a column when data is entered in another column but on the same row.

For example, if someone begins recording data for a new sales prospect in row 345 of Column A, I want to have a time and date recorded in Column B. This time and date record should not change or update. This means that NOW() and TODAY() functions probably wont do the trick.

Mark, I looking for you to hit this one out of park for me buddy.

Kurt


Posted by Sean on May 15, 2001 9:28 AM

Kurt,

I setup something similar for our sales force,

I created an input form that was user friendly, when all the details were completed the user hits the submit button which populates all the information into a flat file (including if you like a date field).

I would recommend that tis approach is better as a form is always easier to move around than a large cumbersome database...

Sean
s-o-s@lineone.net

Posted by Kurt on May 21, 2001 7:36 AM

Thanks.

Kurt