Thread: How do I change column data based on dynamic (rolling) dates?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
MattShoreson MattShoreson is offline
external usenet poster
  
Posts: 1
Default 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

Reply With QuoteReply With Quote