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 pur...
Gourab Dasgupta
Apr 09, 2018Iron 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.