Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions

MC[_4_]

external usenet poster

Posts: 3

Auto insertion of date and time

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Time entry auto changes to date and then time ?	Carol @ Prison[_2_]	Excel Worksheet Functions	1	November 25th 09 10:01 PM
Auto Date & Time	Keyrookie	Excel Worksheet Functions	3	November 22nd 08 09:05 PM
Auto column insertion based on a number	halatree	Excel Worksheet Functions	0	January 11th 08 08:47 PM
Auto row insertion based on a number	Eugene Wong	Excel Worksheet Functions	6	September 28th 07 06:28 AM
Auto insert date/time	Tino	Excel Worksheet Functions	1	September 8th 06 05:58 PM

All times are GMT +1. The time now is 02:10 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us