Inserting a a totals row every nth row.

[Jake87]

I have a list that looks like this:


Site-----Month--Use
Site A----Jan---10
Site A----Feb---5
Site B ----Jan---12
Site B ----Feb---6
Site C----Jan---5
Site C----Feb---3

I need something that will insert a row underneath each individual site grouping and that will sum the use column to look like this:

Site-------Month-Use
Site A------Jan---10
Site A------Feb---5
Total-------------15
Site B ------Jan---12
Site B ------Feb---6
Total-------------18
Site C------Jan---5
Site C------Feb---3
Total--------------8

I understand and can use a pivot table to do this, however i am looking for an alternative, as a pivot table will not work for what i need this to do. Can this be done somehow by pasteing a totals row every nth row or through a macro?

Thanks for any help in advance!

 

[zakasnak]

Re: Inserting a row every nth row.

I don't understand what you are trying to total.

I don't want to total. I just want to insert a row between books & games...

My sheet is 1000 rows long & I have 50 sheets to change.

Sorry for the confusion.

 

[VoG]

Try

Sub InsRows()
Dim LastRow As Long, i As Long, aArea As Range
LastRow = Cells(Rows.Count, "A").End(xlUp).Row
For i = LastRow To 5 Step -1
    If Range("A" & i).Value <> Range("A" & i - 1).Value Then
        Rows(i).Insert
    End If
Next i
For Each aArea In ActiveSheet.UsedRange.Offset(1).SpecialCells(xlCellTypeConstants).Areas
    Cells(aArea.Row + aArea.Rows.Count, 1).Value = Cells(aArea.Row + aArea.Rows.Count - 1, 1).Value
    Cells(aArea.Row + aArea.Rows.Count, 2).Value = Cells(aArea.Row + aArea.Rows.Count - 1, 2).Value
    Cells(aArea.Row + aArea.Rows.Count, 3).Value = "Total"
Next aArea
End Sub

 

[zakasnak]

Try

Sub InsRows()
Dim LastRow As Long, i As Long, aArea As Range
LastRow = Cells(Rows.Count, "A").End(xlUp).Row
For i = LastRow To 5 Step -1
    If Range("A" & i).Value <> Range("A" & i - 1).Value Then
        Rows(i).Insert
    End If
Next i
For Each aArea In ActiveSheet.UsedRange.Offset(1).SpecialCells(xlCellTypeConstants).Areas
    Cells(aArea.Row + aArea.Rows.Count, 1).Value = Cells(aArea.Row + aArea.Rows.Count - 1, 1).Value
    Cells(aArea.Row + aArea.Rows.Count, 2).Value = Cells(aArea.Row + aArea.Rows.Count - 1, 2).Value
    Cells(aArea.Row + aArea.Rows.Count, 3).Value = "Total"
Next aArea
End Sub

This was the result:
we 20101002

<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 10pt; FONT-FAMILY: Trebuchet MS,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 35px"><COL style="WIDTH: 81px"><COL style="WIDTH: 47px"></COLGROUP><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD> </TD><TD>A</TD><TD>B</TD><TD>C</TD></TR><TR style="HEIGHT: 37px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">3</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">Total</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">4</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt">Total</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">5</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Chain</TD><TD style="FONT-SIZE: 8pt">Games</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">6</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Chain</TD><TD style="FONT-SIZE: 8pt">Music</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">7</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Chain</TD><TD style="FONT-SIZE: 8pt">Movies</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">8</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffff"> </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffff; TEXT-ALIGN: left">Chain</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffff">Total</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">9</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffff"> </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffff; TEXT-ALIGN: left">Chain</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffff">Total</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">10</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">9602</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Little</TD><TD style="FONT-SIZE: 8pt">Books</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">11</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">9602</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Little</TD><TD style="FONT-SIZE: 8pt">Games</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">12</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">9602</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Little</TD><TD style="FONT-SIZE: 8pt">Music</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">13</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">9602</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Little</TD><TD style="FONT-SIZE: 8pt">Movies</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">14</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: center">9602</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: left">Little</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffcc">Total</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">15</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: center">9602</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: left">Little</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffcc">Total</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">16</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">9603</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Miller</TD><TD style="FONT-SIZE: 8pt">Books</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">9603</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Miller</TD><TD style="FONT-SIZE: 8pt">Games</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">18</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">9603</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Miller</TD><TD style="FONT-SIZE: 8pt">Music</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">19</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">9603</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Miller</TD><TD style="FONT-SIZE: 8pt">Movies</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: center">9603</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: left">Miller</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffcc">Total</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">21</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: center">9603</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: left">Miller</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffcc">Total</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">22</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">9604</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Sandifer</TD><TD style="FONT-SIZE: 8pt">Books</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">23</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">9604</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Sandifer</TD><TD style="FONT-SIZE: 8pt">Games</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">24</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">9604</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Sandifer</TD><TD style="FONT-SIZE: 8pt">Music</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">25</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">9604</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Sandifer</TD><TD style="FONT-SIZE: 8pt">Movies</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">26</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: center">9604</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: left">Sandifer</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffcc">Total</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">27</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: center">9604</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: left">Sandifer</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffcc">Total</TD></TR></TBODY></TABLE>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4

 

[VoG]

I think that you must have run that on your exhibit containing manually inserted rows. This was my result

Excel Workbook
	A	B	C
1	Store	DL	Dept
2	Chain	Books
3	Chain	Games
4	Chain	Music
5	Chain	Movies
6	Chain	Movies	Total
7	9602	Little	Books
8	9602	Little	Games
9	9602	Little	Music
10	9602	Little	Movies
11	9602	Little	Total
12	9603	Miller	Books
13	9603	Miller	Games
14	9603	Miller	Music
15	9603	Miller	Movies
16	9603	Miller	Total
17	9604	Sandifer	Books
18	9604	Sandifer	Games
19	9604	Sandifer	Music
20	9604	Sandifer	Movies
21	9604	Sandifer	Total
Sheet5 (2)

 

[zakasnak]

I think that you must have run that on your exhibit containing manually inserted rows.

I don't have any manually inserted rows. It's formatted just as I posted except more rows....

I copied just the data I sent you into a new spreadsheet & ran your code & I got the same result as before.

I thought that maybe starting on row 3 would have an affect, but I didn't get the expected results with the data beginning in row 1.

?????

There should be a blank row between books & games?

 

[zakasnak]

This is my expected result: (added bonus would be for the blank cell in column C to read "Comics")

Excel Workbook
	A	B	C
3	Store	DL	Dept
4		Chain	Books
5
6		Chain	Games
7		Chain	Music
8		Chain	Movies
9		Chain	Total
10	9602	Little	Books
11
12	9602	Little	Games
13	9602	Little	Music
14	9602	Little	Movies
15	9602	Little	Total
16	9603	Miller	Books
17
18	9603	Miller	Games
19	9603	Miller	Music
20	9603	Miller	Movies
21	9603	Miller	Total
22	9604	Sandifer	Books
23
24	9604	Sandifer	Games
25	9604	Sandifer	Music
26	9604	Sandifer	Movies
27	9604	Sandifer	Total
we 20101002

 

[VoG]

Sorry but I don't understand the logic. Please explain in words.

 

[zakasnak]

I have 50 sheets each with 1000 rows of data formatted for each department for each store/dm. Current:

we 20101002

<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 10pt; FONT-FAMILY: Trebuchet MS,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 35px"><COL style="WIDTH: 81px"><COL style="WIDTH: 47px"></COLGROUP><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD></TD><TD>A</TD><TD>B</TD><TD>C</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">4</TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Chain</TD><TD style="FONT-SIZE: 8pt">Books</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">5</TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Chain</TD><TD style="FONT-SIZE: 8pt">Games</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">6</TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Chain</TD><TD style="FONT-SIZE: 8pt">Music</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">7</TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Chain</TD><TD style="FONT-SIZE: 8pt">Movies</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">8</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffff"></TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffff; TEXT-ALIGN: left">Chain</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffff">Total</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">9</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">9602</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Little</TD><TD style="FONT-SIZE: 8pt">Books</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">10</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">9602</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Little</TD><TD style="FONT-SIZE: 8pt">Games</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">11</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">9602</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Little</TD><TD style="FONT-SIZE: 8pt">Music</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">12</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">9602</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Little</TD><TD style="FONT-SIZE: 8pt">Movies</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">13</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: center">9602</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: left">Little</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffcc">Total</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">14</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">9603</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Miller</TD><TD style="FONT-SIZE: 8pt">Books</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">15</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">9603</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Miller</TD><TD style="FONT-SIZE: 8pt">Games</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">16</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">9603</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Miller</TD><TD style="FONT-SIZE: 8pt">Music</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">9603</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Miller</TD><TD style="FONT-SIZE: 8pt">Movies</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: center">9603</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: left">Miller</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffcc">Total</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">19</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">9604</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Sandifer</TD><TD style="FONT-SIZE: 8pt">Books</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">20</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">9604</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Sandifer</TD><TD style="FONT-SIZE: 8pt">Games</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">21</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">9604</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Sandifer</TD><TD style="FONT-SIZE: 8pt">Music</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">22</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">9604</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Sandifer</TD><TD style="FONT-SIZE: 8pt">Movies</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">23</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: center">9604</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: left">Sandifer</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffcc">Total</TD></TR></TBODY></TABLE>


I would like to insert a blank row between Books & Games, named Comics for EACH store/dm.

If it could copy the store ID, the DM name (vlookup) & the formulas from the preceding rows (columns D:P), then THAT would be a bonus!

I could select all rows labeled Games & use the insert row to place a blank row above, but with 1000 rows of data on 50 sheets, I was hoping I could find a shortcut. Desired:

we 20101002

<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 10pt; FONT-FAMILY: Trebuchet MS,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 35px"><COL style="WIDTH: 81px"><COL style="WIDTH: 47px"></COLGROUP><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD></TD><TD>A</TD><TD>B</TD><TD>C</TD></TR><TR style="HEIGHT: 37px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">3</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">Store</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">DL</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">Dept</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">4</TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Chain</TD><TD style="FONT-SIZE: 8pt">Books</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">5</TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ffff00"></TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: left">Chain</TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ffff00">Comics</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">6</TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Chain</TD><TD style="FONT-SIZE: 8pt">Games</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">7</TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Chain</TD><TD style="FONT-SIZE: 8pt">Music</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">8</TD><TD style="FONT-SIZE: 8pt"></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Chain</TD><TD style="FONT-SIZE: 8pt">Movies</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">9</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffff"></TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffff; TEXT-ALIGN: left">Chain</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffff">Total</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">10</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">9602</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Little</TD><TD style="FONT-SIZE: 8pt">Books</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">11</TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: center">9602</TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: left">Little</TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ffff00">Comics</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">12</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">9602</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Little</TD><TD style="FONT-SIZE: 8pt">Games</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">13</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">9602</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Little</TD><TD style="FONT-SIZE: 8pt">Music</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">14</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">9602</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Little</TD><TD style="FONT-SIZE: 8pt">Movies</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">15</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: center">9602</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: left">Little</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffcc">Total</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">16</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">9603</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Miller</TD><TD style="FONT-SIZE: 8pt">Books</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17</TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: center">9603</TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: left">Miller</TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ffff00">Comics</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">18</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">9603</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Miller</TD><TD style="FONT-SIZE: 8pt">Games</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">19</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">9603</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Miller</TD><TD style="FONT-SIZE: 8pt">Music</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">20</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">9603</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Miller</TD><TD style="FONT-SIZE: 8pt">Movies</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">21</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: center">9603</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: left">Miller</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffcc">Total</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">22</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">9604</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Sandifer</TD><TD style="FONT-SIZE: 8pt">Books</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">23</TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: center">9604</TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: left">Sandifer</TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ffff00">Comics</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">24</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">9604</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Sandifer</TD><TD style="FONT-SIZE: 8pt">Games</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">25</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">9604</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Sandifer</TD><TD style="FONT-SIZE: 8pt">Music</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">26</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">9604</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Sandifer</TD><TD style="FONT-SIZE: 8pt">Movies</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">27</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: center">9604</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: left">Sandifer</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffcc">Total</TD></TR></TBODY></TABLE>
If you can help, I would be most appreciative!

 

[VoG]

Play with this imperfect code

Sub InsRows()
Dim LastRow As Long, i As Long, aArea As Range
LastRow = Cells(Rows.Count, "A").End(xlUp).Row
For i = LastRow To 2 Step -1
    If Range("C" & i).Value = "Music" Then
        Rows(i).Insert
    End If
Next i
For Each aArea In ActiveSheet.UsedRange.Offset(1).SpecialCells(xlCellTypeConstants).Areas
    Cells(aArea.Row + aArea.Rows.Count, 1).Value = Cells(aArea.Row + aArea.Rows.Count - 1, 1).Value
    Cells(aArea.Row + aArea.Rows.Count, 2).Value = "Comics"
    Cells(aArea.Row + aArea.Rows.Count, 3).Value = "Total"
Next aArea
End Sub

 

[zakasnak]

I adjusted your code a bit...

Sub InsRows()
Dim LastRow As Long, i As Long, aArea As Range
LastRow = Cells(Rows.Count, "A").End(xlUp).Row
For i = LastRow To 2 Step -1
    If Range("C" & i).Value = "Games" Then
        Rows(i).Insert
    End If
Next i
For Each aArea In ActiveSheet.UsedRange.Offset(1).SpecialCells(xlCellTypeConstants).Areas
    Cells(aArea.Row + aArea.Rows.Count, 1).Value = Cells(aArea.Row + aArea.Rows.Count - 1, 1).Value
    Cells(aArea.Row + aArea.Rows.Count, 2).Value = Cells(aArea.Row + aArea.Rows.Count - 1, 1).Value
    Cells(aArea.Row + aArea.Rows.Count, 3).Value = "Comics"
Next aArea
End Sub

But the results are not complete.

• overwriting headers
• the chain & first store losing Books label
• pasting store number where DM should be

we 20101002

<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 10pt; FONT-FAMILY: Trebuchet MS,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 35px"><COL style="WIDTH: 81px"><COL style="WIDTH: 47px"></COLGROUP><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD> </TD><TD>A</TD><TD>B</TD><TD>C</TD></TR><TR style="HEIGHT: 37px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">3</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: center" colSpan=2>Overwriting Headers</TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: center">Comics</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">4</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ffff00">Comics</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">5</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-SIZE: 8pt">Comics</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">6</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Chain</TD><TD style="FONT-SIZE: 8pt">Games</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">7</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Chain</TD><TD style="FONT-SIZE: 8pt">Music</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">8</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Chain</TD><TD style="FONT-SIZE: 8pt">Movies</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">9</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffff"> </TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffff; TEXT-ALIGN: left">Chain</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffff">Total</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">10</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ffff00">Comics</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">11</TD><TD style="FONT-SIZE: 8pt"> </TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ffff00"> </TD><TD style="FONT-SIZE: 8pt">Comics</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">12</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">9602</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Little</TD><TD style="FONT-SIZE: 8pt">Games</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">13</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">9602</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Little</TD><TD style="FONT-SIZE: 8pt">Music</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">14</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">9602</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Little</TD><TD style="FONT-SIZE: 8pt">Movies</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">15</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: center">9602</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: left">Little</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffcc">Total</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">16</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">9603</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Miller</TD><TD style="FONT-SIZE: 8pt">Books</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">9603</TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: left">9603</TD><TD style="FONT-SIZE: 8pt">Comics</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">18</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">9603</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Miller</TD><TD style="FONT-SIZE: 8pt">Games</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">19</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">9603</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Miller</TD><TD style="FONT-SIZE: 8pt">Music</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">20</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">9603</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Miller</TD><TD style="FONT-SIZE: 8pt">Movies</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">21</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: center">9603</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: left">Miller</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffcc">Total</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">22</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">9604</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Sandifer</TD><TD style="FONT-SIZE: 8pt">Books</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">23</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">9604</TD><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #ffff00; TEXT-ALIGN: left">9604</TD><TD style="FONT-SIZE: 8pt">Comics</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">24</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">9604</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Sandifer</TD><TD style="FONT-SIZE: 8pt">Games</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">25</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">9604</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Sandifer</TD><TD style="FONT-SIZE: 8pt">Music</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">26</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: center">9604</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Sandifer</TD><TD style="FONT-SIZE: 8pt">Movies</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">27</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: center">9604</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffcc; TEXT-ALIGN: left">Sandifer</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #ccffcc">Total</TD></TR></TBODY></TABLE>
Any suggestions?