Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi
I have a worksheet of various transactions sorted in date order. There may be 1 row of data for a specific date if there was only one transaction and another date may have 40 rows of data as there were 40 transactions. This is for a complete month so approx 30 days What I would like to do is to run a macro or something that will search down the date column and insert 3 blank rows at every row where the date changes, ie 01/04/2009 changes to 02/04/2009 and then again when that changes to 03/04/2009 and do this for the whole month on the worksheet. I would be grateful if you can give a detailed explanation as to how to do this if it is possible as I have absolutely no idea. Thanks in advance Malcolm |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Text to Rows and then Insert Blank Rows | Excel Discussion (Misc queries) | |||
Insert Blank Rows | Excel Discussion (Misc queries) | |||
How do i insert blank rows between data that is thousands of rows | Excel Discussion (Misc queries) | |||
Insert A blank Row Everytime the date changes in column B | Excel Discussion (Misc queries) | |||
How do I insert blank rows between rows in completed worksheet? | Excel Discussion (Misc queries) |