Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EOMonth function | Excel Worksheet Functions | |||
Creating a Drop Down List with Step by Step Instructions for 2007 | Excel Worksheet Functions | |||
data validation with EOMONTH function | Excel Worksheet Functions | |||
How about adding a quarterly function to Excel like its EOMonth? | Excel Worksheet Functions | |||
How to call EOMONTH(a, b) function | Excel Programming |