| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time Stamping Cells
So I was given this formula from this online help (very grateful by the way,
thanks for the help!!): =IF(A1="","", IF(B1="", NOW(), B1)) But the thing is, it is a shared workbook. So when I hit save on my computer, it does not reflect the time that "cell A1" was originally entered, but rather the time it showed up "updated" on my computer. How can I prevent this from happening? Would it be easier to put in the worksheet_change event that I've been reading about on this site? Whichever is simpler will do. Thanks for all the help everyone. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time Stamping A Cell | Excel Discussion (Misc queries) | |||
| Elapsed time when separate cells contain time and separate date | New Users to Excel | |||
| Running averages and time stamping | Excel Worksheet Functions | |||
| Date and time stamping multiple cells for multiple entries. | Excel Worksheet Functions | |||
| How to chnge 35 relative cells to 35 absolute cells at one time. | Excel Worksheet Functions | |||
Threaded Mode
