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
------------------------
Смотрите видео Excel Automatically Date and Time Stamp When Data is Entered but Don't Change When Data is Modified онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Chester Tugwell 12 Август 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 194,875 раз и оно понравилось 1.3 тысяч людям.