Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Target cell reference moves when target is cut and pasted | Excel Discussion (Misc queries) | |||
Update date field upon cell range change | Excel Worksheet Functions | |||
Update a date cell when a target cell change.... | Excel Discussion (Misc queries) | |||
How to prevent file date change when no update made in Excel? | Excel Discussion (Misc queries) | |||
In adjacent cell, show last date modified of target cell. | Excel Discussion (Misc queries) |