LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Stamping current date when row data changes

Hi,

I am trying to get a cell in a particular column to change to the current
date, but only when any other data in that row is changed. Each cell in
that column then should have the last date that a cell was changed in that
row. We need to be able to perserve the current manual entry of dates last
updated in that column until the next change is made in that row.

I see some talk here about this Worksheet_Change sub, but not quite sure how
to change that to get the result I am looking for. I am sort of new to
writing VB in macros, so you'll have to forgive my lack of knowledge, hoping
someone can steer me to a good solution. Thanks

Craig


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatic date stamping PK Excel Discussion (Misc queries) 16 December 13th 09 10:04 PM
Date stamping a cell change Mustang Excel Discussion (Misc queries) 3 July 15th 09 11:17 PM
Date and time stamping with a (macro) button ArcticWolf Excel Worksheet Functions 4 July 10th 08 12:26 PM
Automatic Date Stamping Risky Dave Excel Programming 1 April 4th 08 02:32 PM
Date stamping based on cell value Bob Excel Programming 6 February 1st 07 03:59 PM


All times are GMT +1. The time now is 01:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"