Hi Guys, I dont know that I correctly described the idea but let me show what I mean: Name Type Pcs Random name 1 A 1 Random name 2 A 6 Random name 3 B 3 Random name 4 B 4 Random name 5 C 6 Random name 6 C 8 Now I want make a macro which will be separating rows with different types by outline. For Example types A will be grouped into 1 "outline ribbon", next will be B then C. It should be determined by type. Just like there: Thanks

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

VBA make outlines for row classess

Thread starter sh1ne
Start date Sep 24, 2018
Tags

make outline random type types

sh1ne

New Member

Sep 24, 2018

Hi Guys,

I dont know that I correctly described the idea but let me show what I mean:
[TABLE="width: 500, align: center"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Type[/TD]
[TD]Pcs[/TD]
[/TR]
[TR]
[TD]Random name 1[/TD]
[TD]A[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Random name 2[/TD]
[TD]A[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]Random name 3[/TD]
[TD]B[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Random name 4[/TD]
[TD]B[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Random name 5[/TD]
[TD]C[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]Random name 6[/TD]
[TD]C[/TD]
[TD]8[/TD]
[/TR]
</tbody>[/TABLE]

Now I want make a macro which will be separating rows with different types by outline. For Example types A will be grouped into 1 "outline ribbon", next will be B then C. It should be determined by type. Just like there: