Forum Discussion
Malcolm McMaster
Apr 09, 2018Copper Contributor
Excel data entry time & date stamp.
I have a large worksheet in which data is entered for a group of suppliers. I would like an automatic entry recorded with each new data line entered to record the date and time of each entry. The purpose is to be able to report the time taken on various dates for each supplier's data.
Any help would be greatly appreciated.
1 Reply
Sort By
- Gourab DasguptaIron Contributor
Hi
1. Open Excel>File>Option>Formulas<Check-"Enable Iterative Calculation"<Change Value Maximum Iterative to 1000
2. Open attached file.
3. hope this will help.