Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to auto update a cell with a current date
I have a spreadsheet which is tracking office issues and has multiple rows.
What I am looking for is a way to have a cell auto update with the current date and time when I update any cell within that row. I know that I can use the Today() function - however this updates the entire spreadsheet when it is opened. I am looking to only update the date in a particular row - if I have made a change to another cell in that row. Thanks for your help!!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to auto update a cell with a current date
I'm guessing you'll have to do this with VBA. I'd look at the
Worksheet_Change event macros first. Maybe someone else can give more info on it. "Kell2604" wrote: I have a spreadsheet which is tracking office issues and has multiple rows. What I am looking for is a way to have a cell auto update with the current date and time when I update any cell within that row. I know that I can use the Today() function - however this updates the entire spreadsheet when it is opened. I am looking to only update the date in a particular row - if I have made a change to another cell in that row. Thanks for your help!!!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to auto update a cell with a current date
Hi Kell,
did you try copy and paste special values for the dates before today? use the today() function and before close the wb, copy and paste special HTH Regards from Brazil Marcelo "Kell2604" escreveu: I have a spreadsheet which is tracking office issues and has multiple rows. What I am looking for is a way to have a cell auto update with the current date and time when I update any cell within that row. I know that I can use the Today() function - however this updates the entire spreadsheet when it is opened. I am looking to only update the date in a particular row - if I have made a change to another cell in that row. Thanks for your help!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I lock cell contents after current date is past? | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Auto update of cell information | Excel Discussion (Misc queries) | |||
extract date from the most current date | Excel Discussion (Misc queries) | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel |