Filter Macro Help

[VBAlicious]

Hello Excel Community,

I have been struggling with coming up with a macro.

I have a column in a spreadsheet that has a list of values some same, some different. This column will be sorted so that it goes ascending from greatest to lowest values and thus same values will be next to each other.

What I am trying to do is have my macro go down this list and insert a row as to seperate rows to isolate similar rows with the same value. For example:
i have I want
134586545
134586545 134586545
134586545 134586545
134586545 134586545
134586545 134586545
134586545
354565463 354565463
354565463 354565463
354565463 354565463


so far my code looks like this:

Please Login or Register  to view this content.

Unfortunately this only works for sets of 2 values and not more. I cant think of a work around to create a space for groups of values with different amounts.

As you can also tell, I have lngrow*3 to account for the spaces the macro does make.

Any help would be greatly appreciated.

Thanks Peeps!

[Greg M]

Hi there,

See if the attached workbook does what you need. It uses the following code:

Please Login or Register  to view this content.

The highlighted values can be altered to suit your requirements.


Hope this helps - please let me know how you get on.

Regards,

Greg M