Extract all data from Sheet1 Based on 1 Cell

[mohdamir1989]

Hi

I am trying to pull data from other sheet based on single cell (Month) reference. Just like a list in one cell. Sheet 1 contains multiple entries segregated with month column.

I need it all in a different format which I need to grab with single validated list.

Any possibilities??

Sheet 1 Format

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD]Order Number[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 129"]
<tbody>[TR]
[TD]Equipment number/Bar Code[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 264"]
<tbody>[TR]
[TD]Material code[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 70"]
<tbody>[TR]
[TD]Parts Qty/ Amount[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 272"]
<tbody>[TR]
[TD]Part Name/ Material description[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 99"]
<tbody>[TR]
[TD]Feedback Date[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 83"]
<tbody>[TR]
[TD]St Loc / CCBPL[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 55"]
<tbody>[TR]
[TD]Sp Stk[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 101"]
<tbody>[TR]
[TD]Valuation Type[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 101"]
<tbody>[TR]
[TD]Price[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 59"]
<tbody>[TR]
[TD]Month[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD]Amount[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD]Station[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

Data to be processed at Sheet 2

[TABLE="class: grid, width: 2524, align: center"]
<tbody>[TR]
[TD="width: 55"]S.No[/TD]
[TD="width: 85"]Complaint#[/TD]
[TD="width: 88"]Order No[/TD]
[TD="width: 79"]Date[/TD]
[TD="width: 145"]Shop Name[/TD]
[TD="width: 108"]Asset code[/TD]
[TD="width: 257"]Fault& Ramedy[/TD]
[TD="width: 317"]Part Change Name[/TD]
[TD="width: 62"]Level[/TD]
[TD="width: 94"]Territory[/TD]
[TD="width: 110"]Amount[/TD]
[TD="width: 272"]Remarks[/TD]
[TD="width: 251"]Agency[/TD]
[TD="width: 207"]Complaint Fwd Date[/TD]
[TD="width: 74"]Closing Date[/TD]
[TD="width: 64"]Total Days[/TD]
[TD="width: 64"]Total Hours[/TD]
[TD="width: 64"]Manual Level[/TD]
[TD="width: 64"]Month[/TD]
[TD="width: 64"]Jan[/TD]
[/TR]
</tbody>[/TABLE]

Only to pick available information upon Month change.

Best Regards

 

[mohdamir1989]

Any guesses?

Hi

I am trying to pull data from other sheet based on single cell (Month) reference. Just like a list in one cell. Sheet 1 contains multiple entries segregated with month column.

I need it all in a different format which I need to grab with single validated list.

Any possibilities??

Sheet 1 Format

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD]Order Number[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 129"]
<tbody>[TR]
[TD]Equipment number/Bar Code[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 264"]
<tbody>[TR]
[TD]Material code[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 70"]
<tbody>[TR]
[TD]Parts Qty/ Amount[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 272"]
<tbody>[TR]
[TD]Part Name/ Material description[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 99"]
<tbody>[TR]
[TD]Feedback Date[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 83"]
<tbody>[TR]
[TD]St Loc / CCBPL[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 55"]
<tbody>[TR]
[TD]Sp Stk[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 101"]
<tbody>[TR]
[TD]Valuation Type[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 101"]
<tbody>[TR]
[TD]Price[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 59"]
<tbody>[TR]
[TD]Month[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD]Amount[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD]Station[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

Data to be processed at Sheet 2

[TABLE="class: grid, width: 2524, align: center"]
<tbody>[TR]
[TD="width: 55"]S.No[/TD]
[TD="width: 85"]Complaint#[/TD]
[TD="width: 88"]Order No[/TD]
[TD="width: 79"]Date[/TD]
[TD="width: 145"]Shop Name[/TD]
[TD="width: 108"]Asset code[/TD]
[TD="width: 257"]Fault& Ramedy[/TD]
[TD="width: 317"]Part Change Name[/TD]
[TD="width: 62"]Level[/TD]
[TD="width: 94"]Territory[/TD]
[TD="width: 110"]Amount[/TD]
[TD="width: 272"]Remarks[/TD]
[TD="width: 251"]Agency[/TD]
[TD="width: 207"]Complaint Fwd Date[/TD]
[TD="width: 74"]Closing Date[/TD]
[TD="width: 64"]Total Days[/TD]
[TD="width: 64"]Total Hours[/TD]
[TD="width: 64"]Manual Level[/TD]
[TD="width: 64"]Month[/TD]
[TD="width: 64"]Jan[/TD]
[/TR]
</tbody>[/TABLE]

Only to pick available information upon Month change.

Best Regards

 

[mohdamir1989]

Any solution?

 

[mohdamir1989]

Hi,

After searching through web regarding the requirement, I found a very close solution in VBA. Now I'm bit stuck with references to month (Validated list in T column)

The code is basically extracting data based on static (Already defined in code) dates. I want the same to use for the month purpose

Sub extractDataBasedOnDate()
Dim lastrow As Long, erow As Long, i As Long
Dim mydate As Date
lastrow = Sheet1.Cells(Rows.Count, 1).End(xlUp).Row
Sheet1.Range(“A1”).Select
For i = 2 To lastrow
    mydate = Cells(i, 2)
[B]If mydate >= “14-mar-2012” And mydate <= “20-mar-2012”[/B] Then
erow = Sheet2.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row
Range(Cells(i, 1), Cells(i, 2)).Copy Destination:=Sheets(“sheet2”).Cells(erow, 1)
End If
Next I
End Sub

Thanking in advance.

Best Regards

 

[Joe4]

Now I'm bit stuck with references to month (Validated list in T column)

Where exactly are these months coming from?
Is it column T of the same row where "mydate" is coming from?
That is only one date, however. What is the other date? Is it always 6 more than the first date?
You should be able to reference them in the code, just like you are referencing cells for "mydate".

 

[mohdamir1989]

Where exactly are these months coming from?
Is it column T of the same row where "mydate" is coming from?
That is only one date, however. What is the other date? Is it always 6 more than the first date?
You should be able to reference them in the code, just like you are referencing cells for "mydate".

Dear Joe,

Thank you for your kind response.

This is base data in sheet named "Material Consuption"
Data in Base sheet can be anywhere from 1st (A:M) Month to be considered for is in "K" Column

[TABLE="class: grid, width: 1493"]
<tbody>[TR]
[TD]Complaint #
(Column A)[/TD]
[TD]Equipment number/Bar Code[/TD]
[TD]Material code[/TD]
[TD]Parts Qty/ Amount[/TD]
[TD]Part Change Name[/TD]
[TD]Feedback Date[/TD]
[TD]St Loc / CCBPL[/TD]
[TD]Sp Stk[/TD]
[TD]Valuation Type[/TD]
[TD]Price[/TD]
[TD]Month[/TD]
[TD]Amount[/TD]
[TD]Service Center
(Column M)[/TD]
[/TR]
</tbody>[/TABLE]

Data to be extracted on Sheet named "Billing" has following format

[TABLE="class: grid, width: 2524"]
<tbody>[TR]
[TD="width: 55"]S.No
(Column A)[/TD]
[TD="width: 85"]Complaint#[/TD]
[TD="width: 88"]Order No[/TD]
[TD="width: 79"]Date[/TD]
[TD="width: 145"]Shop Name[/TD]
[TD="width: 108"]Asset code[/TD]
[TD="width: 257"]Fault& Ramedy[/TD]
[TD="width: 317"]Part Change Name[/TD]
[TD="width: 62"]Level[/TD]
[TD="width: 94"]Territory[/TD]
[TD="width: 110"]Amount[/TD]
[TD="width: 272"]Remarks[/TD]
[TD="width: 251"]Agency[/TD]
[TD="width: 207"]Complaint Fwd Date[/TD]
[TD="width: 74"]Closing Date[/TD]
[TD="width: 64"]Total Days[/TD]
[TD="width: 64"]Total Hours[/TD]
[TD="width: 64"]Manual Level[/TD]
[TD="width: 64"]Month[/TD]
[TD="width: 64"]Jan
(Column T)[/TD]
[/TR]
</tbody>[/TABLE]

Highlighted cells are match in both sheets

Thank you

 

[Joe4]

I don't think that answers the questions I asked.

I was offering to help you with the VBA code that you said almost works, but needs to be adjusted for month references.
Can you please specifically answer the questions I asked in my previous response?

 

[mohdamir1989]

I don't think that answers the questions I asked.

I was offering to help you with the VBA code that you said almost works, but needs to be adjusted for month references.
Can you please specifically answer the questions I asked in my previous response?

Where exactly are these months coming from?
Is it column T of the same row where "mydate" is coming from? (No MyDate is in Sheet1)
That is only one date, however. What is the other date? Is it always 6 more than the first date? (No, it is a full column having data from Dec 2017 till date and so on)
You should be able to reference them in the code, just like you are referencing cells for "mydate". ( I didn't write this code, I am just trying to learn as I mentioned "After searching through web regarding the requirement, I found a very close solution in VBA"

 

[Joe4]

Instead of just headings, can you post some actual data?
Maybe then it will make more sense to us.

 

[mohdamir1989]

Instead of just headings, can you post some actual data?
Maybe then it will make more sense to us.

Dear Joe,

Below is actual data, Month is extracted from date using (=text(cellref,"mmm")

Sheet name (Material Consuption)

I just need to extract data based on Validated list (Column T) in next sheet. If the month changes all the data to related month must be extracted.


[TABLE="class: grid, width: 1493"]
<colgroup><col><col><col><col><col><col><col><col><col span="2"><col><col><col></colgroup><tbody>[TR]
[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]
[TD]M[/TD]
[/TR]
[TR]
[TD]Order Number[/TD]
[TD]Equipment number/Bar Code[/TD]
[TD]Material code[/TD]
[TD]Parts Qty/ Amount[/TD]
[TD]Part Name/ Material description[/TD]
[TD]Feedback Date[/TD]
[TD]St Loc / CCBPL[/TD]
[TD]Sp Stk[/TD]
[TD]Valuation Type[/TD]
[TD]Price[/TD]
[TD]Month[/TD]
[TD]Amount[/TD]
[TD]Service Center[/TD]
[/TR]
[TR]
[TD="align: right"]432007[/TD]
[TD="align: right"]300129869[/TD]
[TD]306-990-353[/TD]
[TD="align: right"]1[/TD]
[TD]Complaint Handling Charges[/TD]
[TD="align: right"]23-Oct-17[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]315[/TD]
[TD]Oct[/TD]
[TD="align: right"]315[/TD]
[TD]Center A[/TD]
[/TR]
[TR]
[TD="align: right"]432009[/TD]
[TD="align: right"]300204495[/TD]
[TD]306-990-353[/TD]
[TD="align: right"]1[/TD]
[TD]Complaint Handling Charges[/TD]
[TD="align: right"]22-Oct-17[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]315[/TD]
[TD]Oct[/TD]
[TD="align: right"]315[/TD]
[TD]Center B[/TD]
[/TR]
[TR]
[TD="align: right"]432017[/TD]
[TD="align: right"]300273446[/TD]
[TD]306-990-353[/TD]
[TD="align: right"]1[/TD]
[TD]Complaint Handling Charges[/TD]
[TD="align: right"]22-Oct-17[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]315[/TD]
[TD]Oct[/TD]
[TD="align: right"]315[/TD]
[TD]Center A[/TD]
[/TR]
[TR]
[TD="align: right"]432018[/TD]
[TD="align: right"]300008058[/TD]
[TD]306-990-591[/TD]
[TD="align: right"]1[/TD]
[TD]COMPLAINT HANDLING SERVICE WARRANTY[/TD]
[TD="align: right"]22-Oct-17[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0.01[/TD]
[TD]Oct[/TD]
[TD="align: right"]0.01[/TD]
[TD]Center B[/TD]
[/TR]
[TR]
[TD="align: right"]432020[/TD]
[TD="align: right"]300376550[/TD]
[TD]306-990-353[/TD]
[TD="align: right"]1[/TD]
[TD]Complaint Handling Charges[/TD]
[TD="align: right"]22-Oct-17[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]315[/TD]
[TD]Oct[/TD]
[TD="align: right"]315[/TD]
[TD]Center A[/TD]
[/TR]
[TR]
[TD="align: right"]432026[/TD]
[TD="align: right"]300229764[/TD]
[TD]306-990-353[/TD]
[TD="align: right"]1[/TD]
[TD]Complaint Handling Charges[/TD]
[TD="align: right"]23-Oct-17[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]315[/TD]
[TD]Oct[/TD]
[TD="align: right"]315[/TD]
[TD]Center B[/TD]
[/TR]
[TR]
[TD="align: right"]432027[/TD]
[TD="align: right"]300446307[/TD]
[TD]306-990-353[/TD]
[TD="align: right"]1[/TD]
[TD]Complaint Handling Charges[/TD]
[TD="align: right"]23-Oct-17[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]315[/TD]
[TD]Oct[/TD]
[TD="align: right"]315[/TD]
[TD]Center A[/TD]
[/TR]
[TR]
[TD="align: right"]432031[/TD]
[TD="align: right"]300293920[/TD]
[TD]306-990-353[/TD]
[TD="align: right"]1[/TD]
[TD]Complaint Handling Charges[/TD]
[TD="align: right"]22-Oct-17[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]315[/TD]
[TD]Oct[/TD]
[TD="align: right"]315[/TD]
[TD]Center B[/TD]
[/TR]
[TR]
[TD="align: right"]432038[/TD]
[TD="align: right"]300676611[/TD]
[TD]306-990-353[/TD]
[TD="align: right"]1[/TD]
[TD]Complaint Handling Charges[/TD]
[TD="align: right"]23-Oct-17[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]315[/TD]
[TD]Oct[/TD]
[TD="align: right"]315[/TD]
[TD]Center A[/TD]
[/TR]
[TR]
[TD="align: right"]432044[/TD]
[TD="align: right"]300010056[/TD]
[TD]306-990-353[/TD]
[TD="align: right"]1[/TD]
[TD]Complaint Handling Charges[/TD]
[TD="align: right"]23-Oct-17[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]315[/TD]
[TD]Oct[/TD]
[TD="align: right"]315[/TD]
[TD]Center B[/TD]
[/TR]
[TR]
[TD="align: right"]432059[/TD]
[TD="align: right"]300005141[/TD]
[TD]306-990-353[/TD]
[TD="align: right"]1[/TD]
[TD]Complaint Handling Charges[/TD]
[TD="align: right"]22-Oct-17[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]315[/TD]
[TD]Oct[/TD]
[TD="align: right"]315[/TD]
[TD]Center A[/TD]
[/TR]
[TR]
[TD="align: right"]432062[/TD]
[TD="align: right"]300368729[/TD]
[TD]306-990-353[/TD]
[TD="align: right"]1[/TD]
[TD]Complaint Handling Charges[/TD]
[TD="align: right"]22-Oct-17[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]315[/TD]
[TD]Oct[/TD]
[TD="align: right"]315[/TD]
[TD]Center B[/TD]
[/TR]
[TR]
[TD="align: right"]432063[/TD]
[TD="align: right"]300367512[/TD]
[TD]306-990-353[/TD]
[TD="align: right"]1[/TD]
[TD]Complaint Handling Charges[/TD]
[TD="align: right"]22-Oct-17[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]315[/TD]
[TD]Oct[/TD]
[TD="align: right"]315[/TD]
[TD]Center A[/TD]
[/TR]
[TR]
[TD="align: right"]432064[/TD]
[TD="align: right"]300271624[/TD]
[TD]306-990-353[/TD]
[TD="align: right"]1[/TD]
[TD]Complaint Handling Charges[/TD]
[TD="align: right"]22-Oct-17[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]315[/TD]
[TD]Oct[/TD]
[TD="align: right"]315[/TD]
[TD]Center B[/TD]
[/TR]
[TR]
[TD="align: right"]432066[/TD]
[TD="align: right"]300366997[/TD]
[TD]306-990-353[/TD]
[TD="align: right"]1[/TD]
[TD]Complaint Handling Charges[/TD]
[TD="align: right"]22-Oct-17[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]315[/TD]
[TD]Oct[/TD]
[TD="align: right"]315[/TD]
[TD]Center A[/TD]
[/TR]
[TR]
[TD="align: right"]432074[/TD]
[TD="align: right"]300246216[/TD]
[TD]306-990-353[/TD]
[TD="align: right"]1[/TD]
[TD]Complaint Handling Charges[/TD]
[TD="align: right"]22-Oct-17[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]315[/TD]
[TD]Oct[/TD]
[TD="align: right"]315[/TD]
[TD]Center B[/TD]
[/TR]
[TR]
[TD="align: right"]432080[/TD]
[TD="align: right"]300352533[/TD]
[TD]306-990-353[/TD]
[TD="align: right"]1[/TD]
[TD]Complaint Handling Charges[/TD]
[TD="align: right"]22-Oct-17[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]315[/TD]
[TD]Oct[/TD]
[TD="align: right"]315[/TD]
[TD]Center A[/TD]
[/TR]
[TR]
[TD="align: right"]432083[/TD]
[TD="align: right"]300600077[/TD]
[TD]306-990-353[/TD]
[TD="align: right"]1[/TD]
[TD]Complaint Handling Charges[/TD]
[TD="align: right"]22-Oct-17[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]315[/TD]
[TD]Oct[/TD]
[TD="align: right"]315[/TD]
[TD]Center B[/TD]
[/TR]
[TR]
[TD="align: right"]432125[/TD]
[TD="align: right"]300324218[/TD]
[TD]306-990-353[/TD]
[TD="align: right"]1[/TD]
[TD]Complaint Handling Charges[/TD]
[TD="align: right"]22-Oct-17[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]315[/TD]
[TD]Oct[/TD]
[TD="align: right"]315[/TD]
[TD]Center A[/TD]
[/TR]
[TR]
[TD="align: right"]432153[/TD]
[TD="align: right"]300313081[/TD]
[TD]306-990-353[/TD]
[TD="align: right"]1[/TD]
[TD]Complaint Handling Charges[/TD]
[TD="align: right"]22-Oct-17[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]315[/TD]
[TD]Oct[/TD]
[TD="align: right"]315[/TD]
[TD]Center B[/TD]
[/TR]
[TR]
[TD="align: right"]432156[/TD]
[TD="align: right"]300131614[/TD]
[TD]306-990-353[/TD]
[TD="align: right"]1[/TD]
[TD]Complaint Handling Charges[/TD]
[TD="align: right"]22-Oct-17[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]315[/TD]
[TD]Oct[/TD]
[TD="align: right"]315[/TD]
[TD]Center A[/TD]
[/TR]
[TR]
[TD="align: right"]432159[/TD]
[TD="align: right"]300013229[/TD]
[TD]306-990-353[/TD]
[TD="align: right"]1[/TD]
[TD]Complaint Handling Charges[/TD]
[TD="align: right"]23-Oct-17[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]315[/TD]
[TD]Oct[/TD]
[TD="align: right"]315[/TD]
[TD]Center B[/TD]
[/TR]
[TR]
[TD="align: right"]432222[/TD]
[TD="align: right"]300354393[/TD]
[TD]306-990-353[/TD]
[TD="align: right"]1[/TD]
[TD]Complaint Handling Charges[/TD]
[TD="align: right"]22-Oct-17[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]315[/TD]
[TD]Oct[/TD]
[TD="align: right"]315[/TD]
[TD]Center A[/TD]
[/TR]
[TR]
[TD="align: right"]432231[/TD]
[TD="align: right"]300336855[/TD]
[TD]306-990-353[/TD]
[TD="align: right"]1[/TD]
[TD]Complaint Handling Charges[/TD]
[TD="align: right"]23-Oct-17[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]315[/TD]
[TD]Oct[/TD]
[TD="align: right"]315[/TD]
[TD]Center B[/TD]
[/TR]
[TR]
[TD="align: right"]432242[/TD]
[TD="align: right"]300359989[/TD]
[TD]306-990-353[/TD]
[TD="align: right"]1[/TD]
[TD]Complaint Handling Charges[/TD]
[TD="align: right"]22-Oct-17[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]315[/TD]
[TD]Oct[/TD]
[TD="align: right"]315[/TD]
[TD]Center A[/TD]
[/TR]
[TR]
[TD="align: right"]432244[/TD]
[TD="align: right"]300439463[/TD]
[TD]306-990-353[/TD]
[TD="align: right"]1[/TD]
[TD]Complaint Handling Charges[/TD]
[TD="align: right"]22-Oct-17[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]315[/TD]
[TD]Oct[/TD]
[TD="align: right"]315[/TD]
[TD]Center B[/TD]
[/TR]
[TR]
[TD="align: right"]432263[/TD]
[TD="align: right"]300263331[/TD]
[TD]306-990-353[/TD]
[TD="align: right"]1[/TD]
[TD]Complaint Handling Charges[/TD]
[TD="align: right"]22-Oct-17[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]315[/TD]
[TD]Oct[/TD]
[TD="align: right"]315[/TD]
[TD]Center A[/TD]
[/TR]
[TR]
[TD="align: right"]432268[/TD]
[TD="align: right"]300157558[/TD]
[TD]306-990-353[/TD]
[TD="align: right"]1[/TD]
[TD]Complaint Handling Charges[/TD]
[TD="align: right"]22-Oct-17[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]315[/TD]
[TD]Oct[/TD]
[TD="align: right"]315[/TD]
[TD]Center B[/TD]
[/TR]
[TR]
[TD="align: right"]432271[/TD]
[TD="align: right"]300157542[/TD]
[TD]306-990-353[/TD]
[TD="align: right"]1[/TD]
[TD]Complaint Handling Charges[/TD]
[TD="align: right"]22-Oct-17[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]315[/TD]
[TD]Oct[/TD]
[TD="align: right"]315[/TD]
[TD]Center A[/TD]
[/TR]
[TR]
[TD="align: right"]432275[/TD]
[TD="align: right"]300013669[/TD]
[TD]306-990-353[/TD]
[TD="align: right"]1[/TD]
[TD]Complaint Handling Charges[/TD]
[TD="align: right"]22-Oct-17[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]315[/TD]
[TD]Oct[/TD]
[TD="align: right"]315[/TD]
[TD]Center B[/TD]
[/TR]
[TR]
[TD="align: right"]432277[/TD]
[TD="align: right"]300157723[/TD]
[TD]306-990-353[/TD]
[TD="align: right"]1[/TD]
[TD]Complaint Handling Charges[/TD]
[TD="align: right"]22-Oct-17[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]315[/TD]
[TD]Oct[/TD]
[TD="align: right"]315[/TD]
[TD]Center A[/TD]
[/TR]
[TR]
[TD="align: right"]432280[/TD]
[TD="align: right"]300454367[/TD]
[TD]306-990-353[/TD]
[TD="align: right"]1[/TD]
[TD]Complaint Handling Charges[/TD]
[TD="align: right"]22-Oct-17[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]315[/TD]
[TD]Oct[/TD]
[TD="align: right"]315[/TD]
[TD]Center B[/TD]
[/TR]
[TR]
[TD="align: right"]432282[/TD]
[TD="align: right"]300662065[/TD]
[TD]306-990-353[/TD]
[TD="align: right"]1[/TD]
[TD]Complaint Handling Charges[/TD]
[TD="align: right"]22-Oct-17[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]315[/TD]
[TD]Oct[/TD]
[TD="align: right"]315[/TD]
[TD]Center A[/TD]
[/TR]
[TR]
[TD="align: right"]432628[/TD]
[TD="align: right"]300032991[/TD]
[TD]306-990-353[/TD]
[TD="align: right"]1[/TD]
[TD]Complaint Handling Charges[/TD]
[TD="align: right"]22-Oct-17[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]315[/TD]
[TD]Oct[/TD]
[TD="align: right"]315[/TD]
[TD]Center B[/TD]
[/TR]
[TR]
[TD="align: right"]432364[/TD]
[TD="align: right"]300134045[/TD]
[TD]306-990-353[/TD]
[TD="align: right"]1[/TD]
[TD]Complaint Handling Charges[/TD]
[TD="align: right"]23-Oct-17[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]315[/TD]
[TD]Oct[/TD]
[TD="align: right"]315[/TD]
[TD]Center A[/TD]
[/TR]
[TR]
[TD="align: right"]432367[/TD]
[TD="align: right"]300134045[/TD]
[TD]306-990-591[/TD]
[TD="align: right"]1[/TD]
[TD]COMPLAINT HANDLING SERVICE WARRANTY[/TD]
[TD="align: right"]23-Oct-17[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0.01[/TD]
[TD]Oct[/TD]
[TD="align: right"]0.01[/TD]
[TD]Center B[/TD]
[/TR]
[TR]
[TD="align: right"]432371[/TD]
[TD="align: right"]300619240[/TD]
[TD]306-990-353[/TD]
[TD="align: right"]1[/TD]
[TD]Complaint Handling Charges[/TD]
[TD="align: right"]23-Oct-17[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]315[/TD]
[TD]Oct[/TD]
[TD="align: right"]315[/TD]
[TD]Center A[/TD]
[/TR]
[TR]
[TD="align: right"]432411[/TD]
[TD="align: right"]300202780[/TD]
[TD]306-990-353[/TD]
[TD="align: right"]1[/TD]
[TD]Complaint Handling Charges[/TD]
[TD="align: right"]22-Oct-17[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]315[/TD]
[TD]Oct[/TD]
[TD="align: right"]315[/TD]
[TD]Center B[/TD]
[/TR]
[TR]
[TD="align: right"]432498[/TD]
[TD="align: right"]300679209[/TD]
[TD]306-990-353[/TD]
[TD="align: right"]1[/TD]
[TD]Complaint Handling Charges[/TD]
[TD="align: right"]23-Oct-17[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]315[/TD]
[TD]Oct[/TD]
[TD="align: right"]315[/TD]
[TD]Center A[/TD]
[/TR]
[TR]
[TD="align: right"]432609[/TD]
[TD="align: right"]300369761[/TD]
[TD]306-990-353[/TD]
[TD="align: right"]1[/TD]
[TD]Complaint Handling Charges[/TD]
[TD="align: right"]22-Oct-17[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]315[/TD]
[TD]Oct[/TD]
[TD="align: right"]315[/TD]
[TD]Center B[/TD]
[/TR]
[TR]
[TD="align: right"]432611[/TD]
[TD="align: right"]300334255[/TD]
[TD]306-990-353[/TD]
[TD="align: right"]1[/TD]
[TD]Complaint Handling Charges[/TD]
[TD="align: right"]22-Oct-17[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]315[/TD]
[TD]Oct[/TD]
[TD="align: right"]315[/TD]
[TD]Center A[/TD]
[/TR]
[TR]
[TD="align: right"]432615[/TD]
[TD="align: right"]300613283[/TD]
[TD]306-990-353[/TD]
[TD="align: right"]1[/TD]
[TD]Complaint Handling Charges[/TD]
[TD="align: right"]22-Oct-17[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]315[/TD]
[TD]Oct[/TD]
[TD="align: right"]315[/TD]
[TD]Center B[/TD]
[/TR]
[TR]
[TD="align: right"]432618[/TD]
[TD="align: right"]300394026[/TD]
[TD]306-990-353[/TD]
[TD="align: right"]1[/TD]
[TD]Complaint Handling Charges[/TD]
[TD="align: right"]22-Oct-17[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]315[/TD]
[TD]Oct[/TD]
[TD="align: right"]315[/TD]
[TD]Center A[/TD]
[/TR]
</tbody>[/TABLE]