About Us

BillyBob

Thank you. This worked quite well.

"Don Guillett" wrote:

Right click sheet tabview codeinsert thissave workbook
now when you change anything in cells d2: d22 the date will be put in col F

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("d2:d22")) Is Nothing Then
Target.Offset(0, 2) = Date
End If
End Sub

--
Don Guillett
SalesAid Software

"BillyBob" wrote in message
...
I have made a spead sheet to enter statistical data into many cells. I want
to see the actual date of entry in another set of cells. Problem is that
everything I have tried up-dates the date cells to today's date each time
I
open the spread sheet. I do not want to depend on the person entering the
data to also manually enter the date.

"Don Guillett" wrote:

Detail?

--
Don Guillett
SalesAid Software

"BillyBob" wrote in message
...
How can I date stamp a cell entry that will not up-date until the entry
is
changed?

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Unhide Worksheets	Wanna Learn	Excel Discussion (Misc queries)	0	November 30th 06 04:38 PM
Unhide Worksheets	Randy L	Excel Discussion (Misc queries)	0	November 30th 06 03:58 PM
Print order of worksheets	Stray Doug	Excel Discussion (Misc queries)	3	September 21st 05 12:37 AM
Duplicate Worksheets	mlofton	Excel Discussion (Misc queries)	1	September 7th 05 02:58 PM
Changing a Link Mid-way Across Worksheets	Frosty	Excel Worksheet Functions	0	August 25th 05 12:03 AM

Menu

About Us