View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jordan Jordan is offline
external usenet poster
 
Posts: 144
Default Change to a Cell causes action

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