Excel Automatically Date and Time Stamp When Data is Entered but Don't Change When Data is Modified скачать в хорошем качестве

Excel Automatically Date and Time Stamp When Data is Entered but Don't Change When Data is Modified

📽️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. 👍👍If you have found this content useful and want to show your appreciation, please use this link to buy me a beer 🍺. https://www.paypal.com/donate/?hosted... Thank you! 👍👍 Download the featured file here: https://www.bluepecantraining.com/aut... 🕰️Timestamps 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 ------------------------