Insert 2 new lines after same text is found

Hi,

If I have a excel 2003 file with a few rows/columns as follows

1234B,AB900,1
1234B,AB900,1
1244A,AB901,1
1267B,AB906,2
1279B,AB915,1
1279B,AB915,3
1279B,AB915,1
1288A,AB922,2

Can it be changed to the following using VBA?

1234B,AB900,1
1234B,AB900,1


1244A,AB901,1


1267B,AB906,2


1279B,AB915,1
1279B,AB915,3
1279B,AB915,1


1288A,AB922,2

Thanks for any help,

David

hi

If i've read it right, you want to insert a blank row (or do something) before each row that is not the same as the one above it (except the 1st). Is that right?

if so, try this

Please Login or Register  to view this content.

apologies for it being a bit messy! Please get back to me if you'd like an explanation of anything, or if there's an error!

cheers

Mat

Hi Mat,

Thanks for your response, you are correct but is it possible to create 2 empty rows in between each set?

Thanks again,

David

should be, just change this

Please Login or Register  to view this content.

to this

Please Login or Register  to view this content.

you will need to modify the line below to be j=j+2, don't think there is anything else, but there might be

Cheers

Mat

That worked thanks for your help Mat.