Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Setting Dates
Is there any way, without using VB, to record when data was entered in a cell? Is there any way, without using VB, to record when data was last modified? Someone else asked me this, and I'm sort of skeptical, as I don't think there is a way to manipulate formulae to do this. We haven't decided what the punishment is for whomever is wrong. Thanks in advance, Scott -- Maistrye ------------------------------------------------------------------------ Maistrye's Profile: http://www.excelforum.com/member.php...o&userid=36078 View this thread: http://www.excelforum.com/showthread...hreadid=560185 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Setting Dates
You asked two questions.
The first one: If the cell (say A1) is blank and someone enters something into that cell, the following formula will tell you the date and time that occurred. However, this formula will update each time the sheet is calculated (even though A1 has not changed) so I don't think you want that. The second question concerns recording when data was last modified. That will take VBA. In fact, VBA will be necessary for both. HTH Otto "Maistrye" wrote in message ... Is there any way, without using VB, to record when data was entered in a cell? Is there any way, without using VB, to record when data was last modified? Someone else asked me this, and I'm sort of skeptical, as I don't think there is a way to manipulate formulae to do this. We haven't decided what the punishment is for whomever is wrong. Thanks in advance, Scott -- Maistrye ------------------------------------------------------------------------ Maistrye's Profile: http://www.excelforum.com/member.php...o&userid=36078 View this thread: http://www.excelforum.com/showthread...hreadid=560185 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Setting Dates
Otto
the first one looks like its what I am trying to do, can you show the formula please as it wasn't stated, I am trying to record the date in cell A1 every time a cell in a range of cells was edited, for example someone entering their hours worked on any given day cell A1 will show that days date I hope this explains it Thanks in advance Tommo "Otto Moehrbach" wrote: You asked two questions. The first one: If the cell (say A1) is blank and someone enters something into that cell, the following formula will tell you the date and time that occurred. However, this formula will update each time the sheet is calculated (even though A1 has not changed) so I don't think you want that. The second question concerns recording when data was last modified. That will take VBA. In fact, VBA will be necessary for both. HTH Otto "Maistrye" wrote in message ... Is there any way, without using VB, to record when data was entered in a cell? Is there any way, without using VB, to record when data was last modified? Someone else asked me this, and I'm sort of skeptical, as I don't think there is a way to manipulate formulae to do this. We haven't decided what the punishment is for whomever is wrong. Thanks in advance, Scott -- Maistrye ------------------------------------------------------------------------ Maistrye's Profile: http://www.excelforum.com/member.php...o&userid=36078 View this thread: http://www.excelforum.com/showthread...hreadid=560185 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pre-1900 dates | Excel Discussion (Misc queries) | |||
Need to pull current dates from list w/many dates | Excel Discussion (Misc queries) | |||
Setting traffic lights based on todays date against target dates | Excel Discussion (Misc queries) | |||
2 digit year in dates return 19xx not 20xx | Excel Discussion (Misc queries) | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) |