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