Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'm trying to get myself a macro so I can analyse my data but after
running it a couple of times (and changing info) the results don't come out as planned. Basically what I'm trying to do is get it to insert two blank rows when a change in data happens. For example: 1 1 1 1 2 2 2 It should insert two blank rows between the 1 and 2. The problem is that the data is not in sequence and sometimes is not a number. I need it to recognise a change regardless of what the value is. Any help/ code would be appreciated |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Insert a blank row after change in data | Excel Worksheet Functions | |||
Auto insert of blank lines | Excel Discussion (Misc queries) | |||
Insert a blank row after change in data | Excel Worksheet Functions | |||
insert a blank row after data changes in a column | Excel Discussion (Misc queries) | |||
auto insert blank line | Excel Discussion (Misc queries) |