Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
automate date entry
i am using excel 2003 and need to automatically insert date into a cell when
i update info in a row. others need to know how current data in a row is. any thoughts out there? please keep in mind that although not a total beginner, certain areas in excel i have never used. thanks in advance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
automate date entry
See if this helps:
http://www.mcgimpsey.com/excel/timestamp.html -- Biff Microsoft Excel MVP "medavino" wrote in message ... i am using excel 2003 and need to automatically insert date into a cell when i update info in a row. others need to know how current data in a row is. any thoughts out there? please keep in mind that although not a total beginner, certain areas in excel i have never used. thanks in advance. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
automate date entry
thank you. with modifications it works except that i need the date/time to
enter and then become constant and not update. is that possible? "T. Valko" wrote: See if this helps: http://www.mcgimpsey.com/excel/timestamp.html -- Biff Microsoft Excel MVP "medavino" wrote in message ... i am using excel 2003 and need to automatically insert date into a cell when i update info in a row. others need to know how current data in a row is. any thoughts out there? please keep in mind that although not a total beginner, certain areas in excel i have never used. thanks in advance. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
automate date entry
Which of the methods suggested there are you using? Don't they each remain
constant? Perhaps you need to look again at your modifications. -- David Biddulph "medavino" wrote in message ... thank you. with modifications it works except that i need the date/time to enter and then become constant and not update. is that possible? "T. Valko" wrote: See if this helps: http://www.mcgimpsey.com/excel/timestamp.html -- Biff Microsoft Excel MVP "medavino" wrote in message ... i am using excel 2003 and need to automatically insert date into a cell when i update info in a row. others need to know how current data in a row is. any thoughts out there? please keep in mind that although not a total beginner, certain areas in excel i have never used. thanks in advance. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
automate date entry
hi david.
once the function NOW is used it automatically updated when s/s is open or f9, etc. i used their formula =IF(A1="","",IF(B1="",NOW(),B1)) my formula is =IF(AL3=1,NOW(),"") "David Biddulph" wrote: Which of the methods suggested there are you using? Don't they each remain constant? Perhaps you need to look again at your modifications. -- David Biddulph "medavino" wrote in message ... thank you. with modifications it works except that i need the date/time to enter and then become constant and not update. is that possible? "T. Valko" wrote: See if this helps: http://www.mcgimpsey.com/excel/timestamp.html -- Biff Microsoft Excel MVP "medavino" wrote in message ... i am using excel 2003 and need to automatically insert date into a cell when i update info in a row. others need to know how current data in a row is. any thoughts out there? please keep in mind that although not a total beginner, certain areas in excel i have never used. thanks in advance. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
automate date entry
So in your change you removed the circular reference which stopped it from
updating. Read again the page to which you were referred (which explains how the methos works), and try the method suggested there. -- David Biddulph "medavino" wrote in message ... hi david. once the function NOW is used it automatically updated when s/s is open or f9, etc. i used their formula =IF(A1="","",IF(B1="",NOW(),B1)) my formula is =IF(AL3=1,NOW(),"") "David Biddulph" wrote: Which of the methods suggested there are you using? Don't they each remain constant? Perhaps you need to look again at your modifications. -- David Biddulph "medavino" wrote in message ... thank you. with modifications it works except that i need the date/time to enter and then become constant and not update. is that possible? "T. Valko" wrote: See if this helps: http://www.mcgimpsey.com/excel/timestamp.html -- Biff Microsoft Excel MVP "medavino" wrote in message ... i am using excel 2003 and need to automatically insert date into a cell when i update info in a row. others need to know how current data in a row is. any thoughts out there? please keep in mind that although not a total beginner, certain areas in excel i have never used. thanks in advance. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
automate date entry
I have reread it several times but don't understand most of it. How / where
do I get the macro into s/s? Want to see if that works. Thanks "David Biddulph" wrote: So in your change you removed the circular reference which stopped it from updating. Read again the page to which you were referred (which explains how the methos works), and try the method suggested there. -- David Biddulph "medavino" wrote in message ... hi david. once the function NOW is used it automatically updated when s/s is open or f9, etc. i used their formula =IF(A1="","",IF(B1="",NOW(),B1)) my formula is =IF(AL3=1,NOW(),"") "David Biddulph" wrote: Which of the methods suggested there are you using? Don't they each remain constant? Perhaps you need to look again at your modifications. -- David Biddulph "medavino" wrote in message ... thank you. with modifications it works except that i need the date/time to enter and then become constant and not update. is that possible? "T. Valko" wrote: See if this helps: http://www.mcgimpsey.com/excel/timestamp.html -- Biff Microsoft Excel MVP "medavino" wrote in message ... i am using excel 2003 and need to automatically insert date into a cell when i update info in a row. others need to know how current data in a row is. any thoughts out there? please keep in mind that although not a total beginner, certain areas in excel i have never used. thanks in advance. |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
automate date entry
Tell us *exactly* where you want the date to appear and tell us *eactly*
what cell(s) this is based on. For example: Whenever a change is made in the range A1:J1 enter the date in cell L1. -- Biff Microsoft Excel MVP "medavino" wrote in message ... I have reread it several times but don't understand most of it. How / where do I get the macro into s/s? Want to see if that works. Thanks "David Biddulph" wrote: So in your change you removed the circular reference which stopped it from updating. Read again the page to which you were referred (which explains how the methos works), and try the method suggested there. -- David Biddulph "medavino" wrote in message ... hi david. once the function NOW is used it automatically updated when s/s is open or f9, etc. i used their formula =IF(A1="","",IF(B1="",NOW(),B1)) my formula is =IF(AL3=1,NOW(),"") "David Biddulph" wrote: Which of the methods suggested there are you using? Don't they each remain constant? Perhaps you need to look again at your modifications. -- David Biddulph "medavino" wrote in message ... thank you. with modifications it works except that i need the date/time to enter and then become constant and not update. is that possible? "T. Valko" wrote: See if this helps: http://www.mcgimpsey.com/excel/timestamp.html -- Biff Microsoft Excel MVP "medavino" wrote in message ... i am using excel 2003 and need to automatically insert date into a cell when i update info in a row. others need to know how current data in a row is. any thoughts out there? please keep in mind that although not a total beginner, certain areas in excel i have never used. thanks in advance. |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
automate date entry
medavino
Right-click on the worksheet tab and "View Code" Copy/paste this code into that sheet module. Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo ws_exit: Application.EnableEvents = False If Not Intersect(Target, Me.Range("A1:A10")) Is Nothing Then With Target If .Value < "" Then .Offset(0, 1).Value = Format(Now, "dd mmm yyyy hh:mm:ss") End If End With End If ws_exit: Application.EnableEvents = True End Sub Any time you make a change in a cell in A1:A10 range, the date/time will appear in corresponding cell in column B Gord Dibben MS Excel MVP On Fri, 21 Dec 2007 07:24:02 -0800, medavino wrote: I have reread it several times but don't understand most of it. How / where do I get the macro into s/s? Want to see if that works. Thanks "David Biddulph" wrote: So in your change you removed the circular reference which stopped it from updating. Read again the page to which you were referred (which explains how the methos works), and try the method suggested there. -- David Biddulph "medavino" wrote in message ... hi david. once the function NOW is used it automatically updated when s/s is open or f9, etc. i used their formula =IF(A1="","",IF(B1="",NOW(),B1)) my formula is =IF(AL3=1,NOW(),"") "David Biddulph" wrote: Which of the methods suggested there are you using? Don't they each remain constant? Perhaps you need to look again at your modifications. -- David Biddulph "medavino" wrote in message ... thank you. with modifications it works except that i need the date/time to enter and then become constant and not update. is that possible? "T. Valko" wrote: See if this helps: http://www.mcgimpsey.com/excel/timestamp.html -- Biff Microsoft Excel MVP "medavino" wrote in message ... i am using excel 2003 and need to automatically insert date into a cell when i update info in a row. others need to know how current data in a row is. any thoughts out there? please keep in mind that although not a total beginner, certain areas in excel i have never used. thanks in advance. |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
automate date entry
hi gord.
this was great code but i need range to be a1:aj1 and date to be in ak. i have over 4000 rows that i need date to always appear in col ak. how do i change code? thanks. "Gord Dibben" wrote: medavino Right-click on the worksheet tab and "View Code" Copy/paste this code into that sheet module. Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo ws_exit: Application.EnableEvents = False If Not Intersect(Target, Me.Range("A1:A10")) Is Nothing Then With Target If .Value < "" Then .Offset(0, 1).Value = Format(Now, "dd mmm yyyy hh:mm:ss") End If End With End If ws_exit: Application.EnableEvents = True End Sub Any time you make a change in a cell in A1:A10 range, the date/time will appear in corresponding cell in column B Gord Dibben MS Excel MVP On Fri, 21 Dec 2007 07:24:02 -0800, medavino wrote: I have reread it several times but don't understand most of it. How / where do I get the macro into s/s? Want to see if that works. Thanks "David Biddulph" wrote: So in your change you removed the circular reference which stopped it from updating. Read again the page to which you were referred (which explains how the methos works), and try the method suggested there. -- David Biddulph "medavino" wrote in message ... hi david. once the function NOW is used it automatically updated when s/s is open or f9, etc. i used their formula =IF(A1="","",IF(B1="",NOW(),B1)) my formula is =IF(AL3=1,NOW(),"") "David Biddulph" wrote: Which of the methods suggested there are you using? Don't they each remain constant? Perhaps you need to look again at your modifications. -- David Biddulph "medavino" wrote in message ... thank you. with modifications it works except that i need the date/time to enter and then become constant and not update. is that possible? "T. Valko" wrote: See if this helps: http://www.mcgimpsey.com/excel/timestamp.html -- Biff Microsoft Excel MVP "medavino" wrote in message ... i am using excel 2003 and need to automatically insert date into a cell when i update info in a row. others need to know how current data in a row is. any thoughts out there? please keep in mind that although not a total beginner, certain areas in excel i have never used. thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date of entry | New Users to Excel | |||
Date issue to automate calendar | Excel Worksheet Functions | |||
Restricting date entry relative to current date | Excel Worksheet Functions | |||
Automate a date referenced in a formula pointing to another sheet | Excel Worksheet Functions | |||
How to automate footers (filename/date) for all new spreadsheets? | Excel Worksheet Functions |