Hello all,

I have a spreadsheet that I am trying to automatically subtotal and add a break before moving to the next group.

Example of how it is now:

test 1 10
test 1 10
test 1 10
test 2 20
test 2 20
test 2 20
test 3 30
test 3 30
test 3 30

Right now I can use the subtotal tool which will do this:

test 1 10
test 1 10
test 1 10
test 1 total 30
test 2 20
test 2 20
test 2 20
test 2 total 80
test 3 30
test 3 30
test 3 30
test 3 total 90

I need to know how to do a macro or format excel to make it look like this:

test 1 10
test 1 10
test 1 10
<b30</b

test 2 20
test 2 20
test 2 20
<b80</b

test 3 30
test 3 30
test 3 30
<b90</b


Please help me! thank you