A Macro to Insert Rows

  • Thread starter Confused_in_Houston
  • Start date
C

Confused_in_Houston

I have repeating data in contiguous cells in a column. I want to insert a
row into the spreadsheet, each time a value in a cell below is not the same
as the value in the cell immediately above. This will create groupings of
identical values and a line between the groups.

What I have now:

AAAA
AAAA
AAAA
BBBB
BBBB
CCCC
DDDD

What a want:

AAAA
AAAA
AAAA

BBBB
BBBB

CCCC

DDDD
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top