Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
increment dates in alternate cells automatically
I have date placed in alternate cells for example A1-01/03/05
C1-02/03/05 D1-03/03/05 F1-04/03/05 till ....30/03/05 What I do is fill up these cells manually for every month, basically by copying the last months dates into a new worksheet and changing it for the new month. Is there a way where i could input a start date and end date on a particular cell or in dialog box and then execute a macro to fill up alternate cells for the given range... Appreciate any help. Thanks. Praz |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dates-Automatically entered in cells | Excel Discussion (Misc queries) | |||
Automatically Increment Row Numbers | New Users to Excel | |||
Excel should let you fill alternate rows automatically | Excel Discussion (Misc queries) | |||
automatically highlight cells with expired dates?! | Excel Discussion (Misc queries) | |||
HOW CAN I AUTOMATICALLY INSERT ALTERNATE BLANK ROWS IN A LIST? | Excel Discussion (Misc queries) |