Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to find odd due dates and move them
All dates are in column E but the data that i get has
9/1/2006 9/10/2006 odd due date this would be moved to column F. and the due date in column E would be changed to 10/1/2006. So on odd due dates we forward the date to the first day of the next month. What i would like to do i create a macro that goes thought Colunm E and moves all dates that are not the fist of the month to column F in the same row and change the date in column E to the first of the next month. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200612/1 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to find and move column | Excel Discussion (Misc queries) | |||
Find account, move them to different sheet MACRO | Excel Discussion (Misc queries) | |||
Macro - Find a value and then move down | Excel Discussion (Misc queries) | |||
macro to find numeric data & move it | Excel Programming | |||
Macro to find the 6th occurrence and move range | Excel Programming |