i'm working on a specialized tracker for audits and in order to verify how much time does the person auditing is taking to get it done i need to create a formula to leave a timestamp.
i've used Now() formula but it works for the first record however when i fill out a second line it will change the actual line and also the ones above or if i ever update any cell in the spreadsheet it will change all the timestamps to the actual date/time.i need to fix it so i can record the information i need. I've read many posts saying that i need to get into VBA codes. i'll attach the file. need help please!
please let me know if there is a formula i can use or trick to fix the result?
or if need to go into VBA could you please help?
thank you sooooo much!