Excel VBA: Insert Row where Cell doesn't equal Previous

A

AndrewOwens

Joined
Dec 8, 2006
Messages
1
Reaction score
0
Hey guys! I know this is simple but I haven't used VBA in a year and I've lost a lot of it! I have a spreadsheet with thirty thousand line items, and in column "M" I have 300 or 400 unique values. I've sorted by those values, but need to insert a line where the record changes. So - I have 1000 line items that's value is "A" and then line 1001 value is "B". I need to insert a blank row so I can sum all of the values of "A". Please help! And many thanks!
 
You must log in or register to reply here.

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

Similar Threads

Insert row(s) with vba 3
Excel VBA 1
VBA - retrieve data on last create named range from previous inserted named range 0
insert row when sum of values equals 100 3
Insert a number of rows based on a value in a cell on active row 1
VBA to insert .xlborder if cell value not equal to previous cell 2
Adding like rows 3
insert row when sum of values equals 100 2

Back
Top