| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto insert date/time
I need to auto insert date/time in column A when an area is picked from
pulldown in column B. I have this: =IF(COUNTA(B45)<0,NOW(),"") it works but it updates all previous in column A. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Auto insert date/time
Cells which contain NOW will recalculate automatically whenever the workbook
is recalculated. Dave -- Brevity is the soul of wit. "Tino" wrote: I need to auto insert date/time in column A when an area is picked from pulldown in column B. I have this: =IF(COUNTA(B45)<0,NOW(),"") it works but it updates all previous in column A. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto insert data to seperate sheets? | New Users to Excel | |||
| Auto insert new row after current row filled in | Excel Discussion (Misc queries) | |||
| auto row insert | Excel Worksheet Functions | |||
| Auto insert values? | Excel Discussion (Misc queries) | |||
| insert picture | Excel Discussion (Misc queries) | |||
Linear Mode
