Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need help with automatic date entry
In a sheet used as a data base, how do I have the current date updated or
changed when the data changes in a record or row. I would like this to show when that record has been modified with out manually changing that cell. |
#2
|
|||
|
|||
Hi
Rightclick the sheet tab, choose "view code", paste this macro in: Private Sub Worksheet_Change(ByVal Target As Range) If Target(1).Column < 5 Then _ Cells(Target(1).Row, 5).Value = Now End Sub Replace 5 with whichever column number your dates are stored in. HTH. Best wishes Harald "Mike200575" skrev i melding ... In a sheet used as a data base, how do I have the current date updated or changed when the data changes in a record or row. I would like this to show when that record has been modified with out manually changing that cell. |
#3
|
|||
|
|||
You can do this with a worksheet_change event macro which is told to use
date in the cell if cells in the row have changed. -- Don Guillett SalesAid Software "Mike200575" wrote in message ... In a sheet used as a data base, how do I have the current date updated or changed when the data changes in a record or row. I would like this to show when that record has been modified with out manually changing that cell. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Turn off automatic date formatting? | Excel Discussion (Misc queries) | |||
import csv without automatic date conversion | Excel Discussion (Misc queries) | |||
Automatic Populate Todays Date in Cell when File is Saved. | Excel Discussion (Misc queries) | |||
Cell converts a date entry to "=" and displays "01/00/00 | Excel Worksheet Functions | |||
auto entry of a date | Excel Worksheet Functions |