| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
auto enter date when another cell populated?
I have an s/sheet with order data: I need to create a macro or formula so
that when data is entered into i.e. Column C, the date is automatically entered into Column A and the time into Column B. The dates / times need to remain static / constant and not update when the file is reopened. Any suggestions? (I've tried an = If(isblank etc.)... with Ctrl+; and Ctrl+Shift+; but my date defaults to 1/1/00). Thanks for your help! -- zim |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Payment cell populated based on date formula | Excel Discussion (Misc queries) | |||
| Auto enter date when data in enter in another cell | Excel Worksheet Functions | |||
| Auto insert Date & Time when another cell is populated | Excel Discussion (Misc queries) | |||
| How to auto-enter date when cell is clicked? | Excel Discussion (Misc queries) | |||
| Can a cell have a drop down list and can also be auto populated | Excel Worksheet Functions | |||
Threaded Mode
