Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro for filling in dates
Hi experts,
I have a small macro problem here I need to solve but can't seem to find my way out. Here is the problem: On Sheet1 column A:A I need to write down names and when I press enter after inputting the info, I want my macro to check if column "I" on the same row is empty and if so fill in that days date (in the "dd.mm.yyyy" format) to this cell on column "I", same row. But if there is already a date there, the macro should ask me if I want to change that date or not before doing so. Is it a simple task?. TIA J_J |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto filling dates | Excel Discussion (Misc queries) | |||
How to satop chart filling in dates | Charts and Charting in Excel | |||
Chart filling in dates that aren't supposed to be there | Charts and Charting in Excel | |||
Filling in specific dates in Excel | Excel Discussion (Misc queries) | |||
Filling in missing dates | Excel Worksheet Functions |