Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How to Automatically Enter Date When Data is Entered in a Column in Excel?
Have you considered whether Excel can automatically record the date of the value entered in the sheet? This can be done in Excel by applying this uncomplicated process to the sheet. For example, if you want to list the main events that occurred on a given day, you can directly enter the name of the event and the date will be generated automatically. This can save you a lot of time as there is no need to enter the date every time, and this cannot even completely use the auto-fill handle because the number of values will be unique and random. This tutorial will help you understand how we can automatically enter dates when data is entered in a column.
Automatically Enter Date When Data is Entered in a Column
Here we will insert VBA code for the sheet to complete our task. Let us see a straightforward process to understand how we can automatically enter dates when data is entered in a column. We need to use the help of a VBA application to complete our process; it cannot be done directly in Excel.
Step 1
Consider creating a new Excel sheet and right-clicking on the sheet name to open the VB application, then typing the programme into the text box as shown in the image below.
Example
Private Sub Worksheet_Change(ByVal Target As Range) 'Updated By Nirmal If Target.Cells.Count > 1 Then Exit Sub If Not Intersect(Target, Range("A2:A15")) Is Nothing Then With Target(1, 2) .Value = Date & " " & Time .EntireColumn.AutoFit End With End If End Sub
Step 2
Now save the sheet as a macro-enabled template and close the VBA application using the command "Alt + Q"; then, every time we enter the data in cells of column "A", the date will be shown in column "B".
Conclusion
In this tutorial, we used a simple example to demonstrate how we can automatically enter dates when data is entered in a column in Excel.
518 Views
