Excel Automatically Date and Time Stamp When Data is Entered but Don't Change When Data is Modified
Download the featured file here: https://www.bluepecantraining.com/aut...
In this video I demonstrate how to date and time stamp your data entry. The NOW() function can be used to return the current date and time but this will change whenever the worksheet is edited. We want the date and time stamp to be fixed. There are two methods I demonstrate for achieving this: the first uses a formula and the second uses a VBA macro. The VBA macro solution also displays when the data was last modified.
Table of Contents:
00:00 - Introduction
00:52 - Formula method for creating a date and time stamp that doesn't change
04:04 - Use a VBA macro to create a date and time stamp
------------------------
Watch video Excel Automatically Date and Time Stamp When Data is Entered but Don't Change When Data is Modified online without registration, duration hours minute second in high quality. This video was added by user Chester Tugwell 12 August 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 194,875 once and liked it 1.3 thousand people.