Posted to microsoft.public.excel.programming
|
|
Auto insertion of date and time
Hi
See: http://www.mcgimpsey.com/excel/timestamp.html
-----Original Message-----
I'm trying to build a spreadsheet to log support calls,
all i need is a way
of inserting the time & date in a column as soon as data
is entered in
another column. I have done this using the Now()
function but the date &
time keep updating, I want them to remain the same as
when the first
appeared.
I have a bit of VB knowledge so am happy to do it this
way if required.
Any ideas?
TIA,
MC
.
|