I am looking for an example of a workbook, with or without VBA code, that automatically inserts the current date in one cell and the current time in a second cell when the contents of a third cell changes.
IOW, if a badge number is entered into cell A1 (for example), I would like the current date to be inserted in B1 and the current time to be inserted in C1. Note that I want to capture the values of the date and time in B1 and C1 such that they won’t change when the date and time change.
Hope I’ve made myself clear.
Thanks, in advance.