View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default How to Auto Date a Row when datea is entered?

J.E. McGimpsey shows a way to put a time stamp on the same row when something
changes:

http://www.mcgimpsey.com/excel/timestamp.html

L. D. James wrote:

A | B | C | D
Date | Debit | Credit | Balance
07/29/06 | 10.00 | | 90.00
07/30/06 | 10.00 | | 80.00
*Formula | | |

*example: @IF(B10+C10=0,"",TODAY())

Can someone help. I would like to write a macro/formula that will put the
date in column a, similar to the foumla I have in the example, however, the
date will remain constant for the time a value was placed in B or C and not
chance when the day change.

Thanks in advance for anyone that has any suggestions or comments on this.

-- L. James

--
-----------------------------
L. D. James

www.apollo3.com/~ljames


--

Dave Peterson