Is there a way to automatically enter a date into a worksheet. I have a sheet with the date in coloumn D. What I would like is a way of the date being entered as soon as a value is entered into column A.
Unfortunately, I also need that date to stay permanently even if the original entry in A is edited at a later date.
For example a salesman could bring a deal into the office and it could be logges in the sheet. If that salesman leaves or if another salesman amends the deal resulting in a different name being entered into A I don't want the original date in D to change.
Is it possible?
Dave
Unfortunately, I also need that date to stay permanently even if the original entry in A is edited at a later date.
For example a salesman could bring a deal into the office and it could be logges in the sheet. If that salesman leaves or if another salesman amends the deal resulting in a different name being entered into A I don't want the original date in D to change.
Is it possible?
Dave