| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change column data based on dynamic (rolling) dates?
write a macro to either hide or delete the month gone. cells(row,col).entirecolumn.delete then insert the next month at the end of the period by using fill. It should be easy enough to record this if you're not experienced with coding. -- MattShoreson ------------------------------------------------------------------------ MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472 View this thread: http://www.excelforum.com/showthread...hreadid=564614 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count data based on past dates | Excel Worksheet Functions | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Macro to move data to different column based on data in another co | Excel Discussion (Misc queries) | |||
| Dynamic Column VlookUps Based on Week Number | Excel Worksheet Functions | |||
Threaded Mode
