| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change date in cell when contents of other cell changes
I have a tracker with 100's of entries. I have a status column and a
date the status last changed. I want to be able to automatically update the date the status last changed when the status changes. Other solutions on here relate to specific cells changing, but I have 100's of cells to listen on and related destination cells. Any ideas? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change date in cell when contents of other cell changes
Extend the Worksheet_Change approach to refer to a specific range, which
contains the changing cells. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ wrote in message oups.com... I have a tracker with 100's of entries. I have a status column and a date the status last changed. I want to be able to automatically update the date the status last changed when the status changes. Other solutions on here relate to specific cells changing, but I have 100's of cells to listen on and related destination cells. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mileage Claim Formula | New Users to Excel | |||
| Change cell colour by date | New Users to Excel | |||
| Change cell color dependin on date ... | Excel Worksheet Functions | |||
| How would I change a date cell to decrease it by business days? | Excel Discussion (Misc queries) | |||
| How do I add a date formula to a cell but hide the contents with . | Excel Discussion (Misc queries) | |||
Linear Mode
