| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if a cell value changes, update date in another cell.
First, I have received two responces and when I've opened them there is
nothing there. I am tring now my home email thinking that our "IT" people have blocked the responces somehow. If I update cell B5 with a new $ amount, I need only cell C5 to update to the current date. Column B are all $ amounts and column C are all dates. Im just a beginner so please keep it simple. Looks like Excel for dummies is too complicated. Any other ideas why the responces are blank????? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if a cell value changes, update date in another cell.
Hi,
Right click your sheet tab, view code and paste this in and try it. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Cells.Count 1 Or IsEmpty(Target) Then Exit Sub Lastrow = Cells(Cells.Rows.Count, "B").End(xlUp).Row If Not Intersect(Target, Range("B1:B" & Lastrow)) Is Nothing Then Application.EnableEvents = False Target.Offset(, 1) = Format(Now, "dd/mm/yyyy") Application.EnableEvents = True End If End Sub Mike "Dave" wrote: First, I have received two responces and when I've opened them there is nothing there. I am tring now my home email thinking that our "IT" people have blocked the responces somehow. If I update cell B5 with a new $ amount, I need only cell C5 to update to the current date. Column B are all $ amounts and column C are all dates. Im just a beginner so please keep it simple. Looks like Excel for dummies is too complicated. Any other ideas why the responces are blank????? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if a cell value changes, update date in another cell.
=if(b2<"",today(),"") remember that today() will put the current date, if you want to fix the date that the $ where typed, you have to copy and past special as number, on the c2. hth -- pleae click yes if it was helpfull regards from Brazil Marcelo "Dave" escreveu: First, I have received two responces and when I've opened them there is nothing there. I am tring now my home email thinking that our "IT" people have blocked the responces somehow. If I update cell B5 with a new $ amount, I need only cell C5 to update to the current date. Column B are all $ amounts and column C are all dates. Im just a beginner so please keep it simple. Looks like Excel for dummies is too complicated. Any other ideas why the responces are blank????? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| if a cell value changes, update date in another cell. | Excel Discussion (Misc queries) | |||
| Automatically update a cell with a date based on anther cells date | Excel Discussion (Misc queries) | |||
| Update a date cell when a target cell change.... | Excel Discussion (Misc queries) | |||
| Populating Last Saved Date in Cell AND also update that same cell in Header | Excel Discussion (Misc queries) | |||
| How to update a cell if a specific date is included in a date rang | Setting up and Configuration of Excel | |||
Linear Mode
