Step 1: EOMONTH Function
 

I'm in step one of creating a macro. The workbook is a position tracker
for the trading company I work fo. I have attached it as a point of
reference for those who care to take a look

Step one is to get a block of cells to row by row shift up as the month
changes. Right now I am using the EOMONTH function with the formula
=EOMONTH(IF(EOMONTH(A1,0)=A1,A1+1,A1),0)+1

This successfully rolls in the next month, but its not copying the
whole row.

For example if the date is 7/1/05 then the next month is August. IF
8/1/05 then next month is Septemtber. I need to be able to roll entire
rows instead of just a few cells. I also need to have the number of
months shown constant, therefore "rolling in" the next month.

Any help is appreciated, the example makes it much clearer. Thanks.


+-------------------------------------------------------------------+
|Filename: Excel forum 5.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3534 |
+-------------------------------------------------------------------+

--
dstock
------------------------------------------------------------------------
dstock's Profile: http://www.excelforum.com/member.php...o&userid=24225
View this thread: http://www.excelforum.com/showthread...hreadid=382014