Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi there, hope somebody can help me!
I am puzzling with a problem: I have a excel 2003 wb with sheets where the cells of 3 colums are representing the results of 1 day. In fact colums F:H do have the results of day 1 of month January to December. Colums CC:CE the results of day 31 of the month January to December. The cells where one can put in or change the numeric data is the range: F2:CE65. Under each day, (3 merged colums of that day), I like to have the last update when someone has changed the data in one of the 3 'day'colums. The problem I encounter is that each time I reopen the workbook the 'Last update' has changed while there was no change in the 3 colums. Also the 'Last update' in other sheets in my workbook have changed but I want only the last updates per 'day' and sheet. Tnx in advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Update date & time in a cell only when worksheet is changed | Excel Discussion (Misc queries) | |||
sheet update date | Excel Programming | |||
Can excel update date when document last changed? | Excel Discussion (Misc queries) | |||
Update sheet after changed Interior.ColorIndex | Excel Programming | |||
Code - if T changed, change date in W to date it is changed | Excel Programming |