Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Good afternoon everyone
Hope someone can help me with this. I have a worksheet that is filled rows of information about transactions. The column A in the worksheet is the date the transaction occured. I would like to have a macro that notices when there is a change in date, and then inserts 3 rows below the final transction on the one date, and the new transctions of the next date. I know how to insert a single row using a macro: Selection.Insert Shift:=x1Down But I can't seem to figure out how to write the IF statement to compare the dates in Column A and insert 3 lines instead of just one. Would really appreciate the help Regards, PVANS |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
inserting rows inbetween rows of data ? | Excel Discussion (Misc queries) | |||
Copying & Inserting Rows w/o Affecting other Rows Etc. | Excel Worksheet Functions | |||
Inserting Blank rows after every row upto 2500 rows | Excel Worksheet Functions | |||
Why is inserting rows throwing off my hidden rows | Excel Programming | |||
Inserting multiple rows in excel with data in consecutive rows | Excel Programming |