Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
put date and time in cells after entry made in shared workbook
I've got a shared workbook which will be used by 5 or 6 users. A user
entry will consist of the user making 6 cell entries or possibly more in the future (one in each of columns C to H). I want the date of entry to appear in the corresponding row of the entry in column A and the time, similarly, in column B when the user saves their entry. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
put date and time in cells after entry made in shared workbook
Do you want the time the entry is made or the time the save is performed??
-- Gary''s Student - gsnu2007g "robzrob" wrote: I've got a shared workbook which will be used by 5 or 6 users. A user entry will consist of the user making 6 cell entries or possibly more in the future (one in each of columns C to H). I want the date of entry to appear in the corresponding row of the entry in column A and the time, similarly, in column B when the user saves their entry. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
put date and time in cells after entry made in shared workbook
On Apr 10, 8:19*pm, Gary''s Student
wrote: Do you want the time the entry is made or the time the save is performed?? -- Gary''s Student - gsnu2007g "robzrob" wrote: I've got a shared workbook which will be used by 5 or 6 users. *A user entry will consist of the user making 6 cell entries or possibly more in the future (one in each of columns C to H). *I want the date of entry to appear in the corresponding row of the entry in column A and the time, similarly, in column B when the user saves their entry.- Hide quoted text - - Show quoted text - Sorry - when the save is performed would be best! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula that will record the time and date when an entry is made on a sheet | Excel Worksheet Functions | |||
Data Entry in shared workbook | Excel Discussion (Misc queries) | |||
Data Entry in a Shared Workbook | Excel Worksheet Functions | |||
Last data entry made time and Date show in each worksheet | Excel Worksheet Functions | |||
After a date entry is made, only displaying the Day | Excel Discussion (Misc queries) |