| 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. |
| 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) | |||
Threaded Mode
