VBA help Object variable not set (Error 91)

justme1122 · Aug 4, 2011

Hi guys

Sorry, im rather new to VBA and having a little bit of a problem with this error:

Object variable not set (Error 91)

From my understanding something s missing from the top few lines but im unsure how to fix it.

PHP:

Sub Shift_Data()
    Dim Found           As Range, col As Long, Lastrow As Long
    Dim ws              As Worksheet
    
    
    Application.ScreenUpdating = False
    For Each ws In Worksheets
        col = 1
        Set Found = ws.Columns(col).Find("SubTotal", , xlValues, xlWhole, xlByRows, xlNext, False)
        If Not Found Is Nothing Then
            Lastrow = ws.Range("k" & Rows.Count).End(xlUp).Row
            If Found.Row <> Lastrow Then
                Do
                    ws.Range(Found.Offset(1), ws.Cells(Lastrow, col)).Insert Shift:=xlToRight
                    col = col + 1
                    Set Found = ws.Columns(col).Find("SubTotal")
                Loop Until Found.Row = Lastrow
            End If
        End If
    Next ws
    Application.ScreenUpdating = True
End Sub

There line that debug highllights is in red.

Thanks so much for any help
scott

baitmaster · Aug 4, 2011

row not highlighted in red, but...

use option explicit at the top of your code if you're not already doing so

"k" & Rows.Count needs qualifying: rows refers to the active sheet, not ws

What do you do if ws has no data? I guess you want to refer to the usedrange, not all cells - and if the usedrange is nothing, then you might get an error

justme1122 · Aug 4, 2011

thanks for the reply

Sorry, I guess colouring does not work php

Debug show error here:

PHP:

 Loop Until Found.Row = Lastrow

Sorry for my noobness but:

is "K" a cell ref?

and how would I qualify row.counts

Thanks
scott

PS:
I did try a little trial and error with trying to qualifying using other code that I have as examples but could not get it to work.

baitmaster · Aug 4, 2011

you probably want ws.rows.count or something similar - if you dont state which ws you are looking at, it will default to the active sheet. In this case you are looping through every sheet and only looking at cells based on parameters of one of them, I assume you want that to vary for every sheet

Your Do Loop is having problems because, I believe, your lastRow is not defining correctly. Its dangerous to have a Do Loop set up without some failsafe to break out in cases like this

"K" is the column reference. You are appending to lastrow to create something like say "K10". You could also reference your range in a different way, such as cells(lastrow,11)

Stick a msgbox in, to see what found.row and lastRow are returning before you use them

justme1122 · Aug 4, 2011

ok so now im really lost on confused, any chance someone could noob the above.

So from scrach I have a sheet with the word subtotal on it many times. Every time it finds the word subtotal I want it to move everthing under it one cell to the right. I then want it to select the next worksheet (there are a few hundred) and do the same.

thanks
scott

baitmaster · Aug 5, 2011

There are a few problems here

The main one is what you are actually trying to achieve, because you can encounter unexpected errors with it, depending how your data is laid out, and how it might change. It will be easier to adjust your code than try to go into too much detail, but I need more info:

How many times does "subtotal" appear on each sheet? on each column? and on each row? (reasons may be clear form next questions)
What do you mean by "under"? All rows below that cell? Just the cells below it, on the same column? What if those cells contain "subtotal", this could end up moving stuff all over the place? What if the destination cells contain data?

Are you looking only for whole cells containing "subtotal" and nothing else? or the SUBTOTAL formula? You are currently looking for cells containing exactly "subtotal" and nothing else

Your code currently does nothing if subtotal is not found in column 1, but your description mentions "many times", and your code looks at other columns IF something is found in column 1. I assume you want it to look for all instances, regardless of whether one is in column 1

Lastrow = ws.Range("k" & ws.Rows.Count).End(xlUp).Row

You are referring to a range on the worksheet "WS". But by counting "rows.count", VBA is defaulting to look at the activesheet to count the rows. By changing this to "ws.rows.count" you are telling VBA to count the rows on WS, and use this number to define the range on WS...

If Not Found Is Nothing Then
You are using this to ensure there are no issues if the term "subtotal" is not found. You haven't got an error handler like this after the next FIND line, which I've just noticed (finally, sorry!) is also missing some text

attempt 1:
Set Found = ws.Columns(col).Find("SubTotal", , xlValues, xlWhole, xlByRows, xlNext, False)
attempt 2:
Set Found = ws.Columns(col).Find("SubTotal")

You are currently always looking for the last row that is used in column K, I'm not sure you want to do that. Do you not just want to use the same last row for each column on the sheet?

justme1122 · Aug 5, 2011

Hi, thanks again for your time, I will try your suggested change when I get to work. but in the mean time.

So im try to change the following.

Excel Workbook

A

B

C

D

5

Stock

6

Accessories

7

Blank Tapes

8

Chips

9

Confectionery

10

Disk Repair/Cleaning

11

Drinks

12

Ice Creams

13

Member Admin Fees

14

Misc Food Items

15

Miscellaneous items

16

News/Mags/Books

17

Popcorn

18

Promo Merchandise

19

Virgin Accessories

20

Vouchers

21

Subtotal

22

Ex-rental

23

Game, Nintendo Wii

24

Game, PlayStation 2

25

Game, Playstation 3

26

Game, X-Box

27

Game, X-Box 360

28

Movie, Blu-Ray

29

Movie, DVD

30

TV, DVD

31

Subtotal

32

Rental

33

Accessories, Nintendo Wii

34

Game, Nintendo Wii

35

Game, PlayStation 2

36

Game, Playstation 3

37

Game, X-Box

38

Game, X-Box 360

39

Movie, Blu-Ray

40

Movie, DVD

41

TV, DVD

42

Subtotal

43

Sell Through

44

Accessories, PC Compatible

45

Game, DreamCast

46

Game, Nintendo Wii

47

Game, PC compatible

48

Game, PlayStation 2

49

Game, Playstation 3

50

Game, X-Box 360

51

Movie, Blu-Ray

52

Movie, DVD

53

Movie, DVD - Vanilla

54

TV, Blu-Ray

55

TV, DVD

56

Subtotal

Sheet

to this

<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 10pt; FONT-FAMILY: Arial,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"></COLGROUP><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><TD>D</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">5</TD><TD style="FONT-WEIGHT: bold; FONT-STYLE: italic; TEXT-ALIGN: left">Stock</TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">6</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Accessories </TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">7</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Blank Tapes </TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">8</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Chips </TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">9</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Confectionery </TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">10</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Disk Repair/Cleaning</TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">11</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Drinks </TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">12</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Ice Creams </TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">13</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Member Admin Fees </TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">14</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Misc Food Items </TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">15</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Miscellaneous items </TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">16</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">News/Mags/Books </TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Popcorn </TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">18</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Promo Merchandise </TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">19</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Virgin Accessories </TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">20</TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Vouchers </TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">21</TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: left">Subtotal</TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">22</TD><TD></TD><TD style="FONT-WEIGHT: bold; FONT-STYLE: italic; TEXT-ALIGN: left">Ex-rental </TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">23</TD><TD></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Game, Nintendo Wii </TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">24</TD><TD></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Game, PlayStation 2 </TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">25</TD><TD></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Game, Playstation 3 </TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">26</TD><TD></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Game, X-Box </TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">27</TD><TD></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Game, X-Box 360 </TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">28</TD><TD></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Movie, Blu-Ray </TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">29</TD><TD></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Movie, DVD </TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">30</TD><TD></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">TV, DVD </TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">31</TD><TD></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: left">Subtotal</TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">32</TD><TD></TD><TD></TD><TD style="FONT-WEIGHT: bold; FONT-STYLE: italic; TEXT-ALIGN: left">Rental </TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">33</TD><TD></TD><TD></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Accessories, Nintendo Wii </TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">34</TD><TD></TD><TD></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Game, Nintendo Wii </TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">35</TD><TD></TD><TD></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Game, PlayStation 2 </TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">36</TD><TD></TD><TD></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Game, Playstation 3 </TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">37</TD><TD></TD><TD></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Game, X-Box </TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">38</TD><TD></TD><TD></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Game, X-Box 360 </TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">39</TD><TD></TD><TD></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Movie, Blu-Ray </TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">40</TD><TD></TD><TD></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Movie, DVD </TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">41</TD><TD></TD><TD></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">TV, DVD </TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">42</TD><TD></TD><TD></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: left">Subtotal</TD><TD></TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">43</TD><TD></TD><TD></TD><TD></TD><TD style="FONT-WEIGHT: bold; FONT-STYLE: italic; TEXT-ALIGN: left">Sell Through </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">44</TD><TD></TD><TD></TD><TD></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Accessories, PC Compatible </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">45</TD><TD></TD><TD></TD><TD></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Game, DreamCast </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">46</TD><TD></TD><TD></TD><TD></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Game, Nintendo Wii </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">47</TD><TD></TD><TD></TD><TD></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Game, PC compatible </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">48</TD><TD></TD><TD></TD><TD></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Game, PlayStation 2 </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">49</TD><TD></TD><TD></TD><TD></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Game, Playstation 3 </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">50</TD><TD></TD><TD></TD><TD></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Game, X-Box 360 </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">51</TD><TD></TD><TD></TD><TD></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Movie, Blu-Ray </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">52</TD><TD></TD><TD></TD><TD></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Movie, DVD </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">53</TD><TD></TD><TD></TD><TD></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">Movie, DVD - Vanilla </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">54</TD><TD></TD><TD></TD><TD></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">TV, Blu-Ray </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">55</TD><TD></TD><TD></TD><TD></TD><TD style="FONT-SIZE: 8pt; TEXT-ALIGN: left">TV, DVD </TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">56</TD><TD></TD><TD></TD><TD></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: left">Subtotal</TD></TR></TABLE>

-There is data in the cells to the e,f,g,h,ect.
-There are also some tables below that is formatted in a diferent way but we should not worry about them for now.
-Data from the csv's are not in constant positions, ie the data could be anyware from 20 rows long to 100.
-I have around 200 sheets in which i want to do this in.
-In theroy there is only 5 sections (the word "subtotal" 5 times), but due to the nature of the reports this may not be the case in the distant past or future.

There reason that I use colum "K" is that in my noobness I was worried that the code may have been look for the last row after every loop, "K" always has data in the last row befor and after each loop.

Again thanks for your time.

scott

baitmaster · Aug 5, 2011

better way to find the last row:

Code:

lastRow = ws.Cells.Find("*", Range("A1"), xlFormulas, , xlByRows, xlPrevious).Row

use it directly after

Code:

for each ws in worksheets

My main concern though is about shifting adjacent columns when you don't want to, and/or overwriting data where you shouldn't. Thats why I think I still need to see examples of all data in a sheet, not just column 1 - We can create some code for column 1, but the key to coding is to cover all other problems that may occur unexpectedly, and I think we will get some here

justme1122 · Aug 5, 2011

hi

So I currently have the following with the error being:

PHP:

Loop Until Found.Row = Lastrow

error: found.row =< object varriable or with block varriable not set

the current code is:

Code:

Sub Shift_Data()
    Dim Found           As Range, col As Long, Lastrow As Long
    Dim ws              As Worksheet
 
 
    Application.ScreenUpdating = False
    For Each ws In Worksheets
        Lastrow = ws.Cells.Find("*", Range("A1"), xlFormulas, , xlByRows, xlPrevious).Row
        col = 1
        Set Found = ws.Columns(col).Find("SubTotal", , xlValues, xlWhole, xlByRows, xlNext, False)
        If Not Found Is Nothing Then
            If Found.Row <> Lastrow Then
                Do
                    ws.Range(Found.Offset(1), ws.Cells(Lastrow, col)).Insert Shift:=xlToRight
                    col = col + 1
                    Set Found = ws.Columns(col).Find("SubTotal")
 
               Loop Until Found.Row = Lastrow
 
           End If
 
        End If
    Next ws
    Application.ScreenUpdating = True
End Sub

as requested full sheet, data has been replaced with 1's:

2010w03

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD></TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD><TD>I</TD><TD>J</TD><TD>K</TD><TD>L</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 12pt; FONT-WEIGHT: bold">0603 Sales Summary Report 13/07/2009 - 19/07/2009</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt">Date of print:</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 10pt">1/01/1990</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-FAMILY: Arial; FONT-SIZE: 10pt">* Dollar amounts on Sales Summary are inc gst unless stated otherwise</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt">Store:</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 10pt">####, name</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">% Total Revenue</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">Qty Rented/Sold</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">Revenue exc GST</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">Revenue inc GST</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">Avg trans value</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">Description</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">GST</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Stock</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt">Confectionery </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt">Drinks </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt">Ice Creams </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt">Popcorn </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt">Vouchers </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Subtotal</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Ex-rental </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt">Game, PlayStation 2 </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt">Movie, DVD </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Subtotal</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Rental </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">17</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt">Game, Nintendo Wii </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">18</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt">Game, PlayStation 2 </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">19</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt">Game, Playstation 3 </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">20</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt">Game, X-Box </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">21</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt">Game, X-Box 360 </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">22</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt">Movie, Blu-Ray </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">23</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt">Movie, DVD </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">24</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Subtotal</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">25</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Sell Through </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">26</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt">Accessories, PC Compatible </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">27</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt">Game, PC compatible </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">28</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt">Movie, DVD </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">29</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Subtotal</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">30</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Overdues collected</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">31</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt">Game, Nintendo Wii </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">32</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt">Game, Playstation 3 </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">33</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt">Game, X-Box 360 </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">34</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt">Movie, Blu-Ray </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">35</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt">Movie, DVD </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">36</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt">Unspecified, Unspecified </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">37</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Subtotal</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">38</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold">Grand Total</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">39</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">Page 1 of 3</TD></TR></TBODY></TABLE>
2010w03

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD> </TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD><TD>I</TD><TD>J</TD><TD>K</TD><TD>L</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">40</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 12pt; FONT-WEIGHT: bold">0603 Sales Summary Report 13/07/2009 - 19/07/2009</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt">Date of print:</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 10pt">1/01/1990</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">41</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-FAMILY: Arial; FONT-SIZE: 10pt">* Dollar amounts on Sales Summary are inc gst unless stated otherwise</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt">Store:</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 10pt">####, name</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">42</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">% Total Revenue</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">Qty Rented/Sold</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">Revenue exc GST</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">Revenue inc GST</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">Avg trans value</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">43</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">Description</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">GST</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">44</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">45</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">POR / Member Credit</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">Security Deposits</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">46</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt">$ Credit used</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt">$ Taken</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">47</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt">$ Credit applied</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt">$ Refunded</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">48</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt">$ Credit balance (to date)</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt">$ Kept (to date)</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">49</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt">$ Credit Cancelled/Refunded Lay-by</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt">$ Balance (to date)</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">50</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 8pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">51</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt">$ POR Transactions</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">Add Fees</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">52</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt">$ POR payments</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">53</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt">$ Charged</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">54</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt">$ Paid</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">55</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt">$ Pardoned</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">56</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">57</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">Refund</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">58</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt">$ Refunded (exc. GST)</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">59</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">60</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">Team Members Sales</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">61</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 7pt; FONT-WEIGHT: bold">$ Earnings (inc. GST)</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 7pt; FONT-WEIGHT: bold">% Earnings</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 7pt; FONT-WEIGHT: bold">$ Late Fee Paid</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 7pt; FONT-WEIGHT: bold">$ Late Fee Pardoned</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 7pt; FONT-WEIGHT: bold">$ Debt Admin Fee Paid</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 7pt; FONT-WEIGHT: bold">$ Debt Admin Fee Pardoned</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 7pt; FONT-WEIGHT: bold">$ Deposit Taken</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 7pt; FONT-WEIGHT: bold">$ Total Lay-bys</TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">62</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt">staff name</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt">1.00</TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">63</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt">staff name</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt">1.00</TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">64</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt">staff name</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt">1.00</TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">65</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt">staff name</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt">1.00</TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">66</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt">staff name</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt">1.00</TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">67</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt">staff name</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt">1.00</TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">68</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">Total</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt; FONT-WEIGHT: bold">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt; FONT-WEIGHT: bold">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt; FONT-WEIGHT: bold">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt; FONT-WEIGHT: bold">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt; FONT-WEIGHT: bold">1.00</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt; FONT-WEIGHT: bold">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 7pt; FONT-WEIGHT: bold">1.00</TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">69</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-FAMILY: Arial; FONT-SIZE: 10pt">* BPay = All Store BPay Payments</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">70</TD><TD style="TEXT-ALIGN: left; FONT-STYLE: italic; FONT-FAMILY: Arial; FONT-SIZE: 10pt">* Debt BPay = All Entertainment Recoveries Payments including admin fees</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">71</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">Members</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt; FONT-WEIGHT: bold">Rental in Store (to date)</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">72</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt">Members (to date)</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt">DVD</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD></TR><TR style="HEIGHT: 15px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">73</TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt">Active members</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Arial; FONT-SIZE: 8pt">Game</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 8pt">1.00</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> </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

again thank you for your time
scott

justme1122 · Aug 5, 2011

also the main reason I want to move the data is so that I can vlookup data. The reason that I cant at the moment is that a sub heading like "Game, Nintendo Wii" could be in under one of the bold heading 5 times or none.

My thought that the easyest way to fix this it to move the data side ways, thus I just need to change my vlookup range by one colum for each of the bold heading.

ie:
in my first worksheet:

to lookup Stock i use : =IF(ISERROR(VLOOKUP($B2,INDIRECT(C$1&"!$a$4:$q$75"),8,0)),0,VLOOKUP($B2,INDIRECT(C$1&"!$a$4:$q$75"),8,0))

for a Ex-rental i sue: =IF(ISERROR(VLOOKUP($B18,INDIRECT(C$1&"!$b$4:$q$75"),8,0)),0,VLOOKUP($B18,INDIRECT(C$1&"!$b$4:$q$75"),8,0))

I was thinking this would be the best approach as if some time in the future more bold heading are added then I would be able to simple.

Also I dont know if it make smuch differance but if you had not guessed Im trying to make a data table for a few years worth of data so that I may chart it. I got the sheet fully set up apart from this one script to move the data into the right colums.

thanks
scott

VBA help Object variable not set (Error 91)

justme1122

New Member

Excel Facts

baitmaster

Well-known Member

justme1122

New Member

baitmaster

Well-known Member

justme1122

New Member

baitmaster

Well-known Member

justme1122

New Member

baitmaster

Well-known Member

justme1122

New Member

justme1122

New Member

Similar threads

Forum statistics

Share this page

VBA help Object variable not set (Error 91)

New Member

Excel Facts

Well-known Member

New Member

Well-known Member

New Member

Well-known Member

New Member

Well-known Member

New Member

New Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock