Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Good Morning,
I would like to solve this with a formula if at all possible. I want my workbook to record, in the adjacent cell, when someone makes a change to a cell in column A. So in cells B3:B10 the equations a =IF(A3="","",NOW()) =IF(A4="","",NOW()) and so on. The problem I have is that when I update any of those cells, the dates for all of them change. Is there a way to setup the workbook so that if someone updates A5, only the date in B5 changes? Thanks a bunch, jordan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Change Template Double Click behavior / action | Excel Discussion (Misc queries) | |||
Change in action when converting to *.xla | Excel Programming | |||
Cell change causes action | Excel Programming | |||
Evaluate cells for change and then action | Excel Programming | |||
Automating a date field to change on certain action | Excel Programming |