Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Update Date Cell when any of target cells change

I have a row of user entered data (B-AP7) and a date cell (A7). I would like
to update A7 with the current date any time one or more cells in B7-AP7
changes. If there is no change, A7 stays constant. I would like to repeat
this functionality for the next 99 rows.

Basically, I want to know the when was the most recent update for each row
of data in a worksheet.

I appreciate any assistance.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4,624
Default Update Date Cell when any of target cells change

See

http://www.mcgimpsey.com/excel/timestamp.html

In article ,
DAKent wrote:

I have a row of user entered data (B-AP7) and a date cell (A7). I would like
to update A7 with the current date any time one or more cells in B7-AP7
changes. If there is no change, A7 stays constant. I would like to repeat
this functionality for the next 99 rows.

Basically, I want to know the when was the most recent update for each row
of data in a worksheet.

I appreciate any assistance.

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Update Date Cell when any of target cells change

That is almost exactly what I am looking. Your example shows how to look for
changes in a column range and write the date in the next column. I need to
figure out how to look at a row(s) range (B-AP) and date stamp a change in
the A cell of the same row(s).

Thanks for your help!

"JE McGimpsey" wrote:

See

http://www.mcgimpsey.com/excel/timestamp.html

In article ,
DAKent wrote:

I have a row of user entered data (B-AP7) and a date cell (A7). I would like
to update A7 with the current date any time one or more cells in B7-AP7
changes. If there is no change, A7 stays constant. I would like to repeat
this functionality for the next 99 rows.

Basically, I want to know the when was the most recent update for each row
of data in a worksheet.

I appreciate any assistance.


Reply
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
Target cell reference moves when target is cut and pasted Illya Teideman Excel Discussion (Misc queries) 5 May 31st 07 11:34 AM
Update date field upon cell range change Carole O Excel Worksheet Functions 1 May 16th 07 05:04 AM
Update a date cell when a target cell change.... chongcc Excel Discussion (Misc queries) 5 April 20th 07 01:02 AM
How to prevent file date change when no update made in Excel? John2348 Excel Discussion (Misc queries) 0 June 16th 06 04:27 PM
In adjacent cell, show last date modified of target cell. manxman Excel Discussion (Misc queries) 0 March 17th 06 11:47 PM


All times are GMT +1. The time now is 08:20 PM.

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

About Us

"It's about Microsoft Excel"