Spreadsheet: 99503d1298117163-finding-data-from-other-sheets-main
Sheet: wc 2-8-10

 | Claims sent from: |  | BELLE VALE |  |  |  |  |  |  | Date:
 | Exporting office |  |  |  |  |  |  | Importing Office |  |  |  |  | CCG section
 | Surname | First Name | NINO | Date Sent | App NO | Bundle No | Bag No | Date recd by exprting office | date of decision | Name of DM | [NAME] to Belle Vale | Bag No | Date rec by [NAME] | Date cleared on S/F tracker
1 | MCDOWELL | ADELE | JW005373B | 2010-08-05 00:00:00 | 17 | 1 | 1
2 | MCGRATH | JANETTE | [NAME] | 2010-08-05 00:00:00 | 31 | 1 | 1
3 | MCKINNEY | LISA | NX745798D | 2010-08-05 00:00:00 | 1 | 1 | 1
4 | MCMICHAEL | ALBERT | YE933492D | 2010-08-05 00:00:00 | 1 | 1 | 1
5 | MAGUIRE | LYNDSEY | JS487199D | 2010-08-05 00:00:00 | 6 | 1 | 1
6 | MALONE | BERNARD | YB348079A | 2010-08-05 00:00:00 | 87 | 1 | 1
7 | MARR | SAMANTHA | JH707226C | 2010-08-05 00:00:00 | 1 | 1 | 1
8 | MELIA | PATRICIA | YK837815B | 2010-08-05 00:00:00 | 26 | 1 | 1
9 | MING | ADAM | JS904704A | 2010-08-05 00:00:00 | 4 | 1 | 1
10 | MOLYNEUX | MARIT | PW715834C | 2010-08-05 00:00:00 | 35 | 1 | 1
11 | MULLARKEY | ANN | YT988171A | 2010-08-05 00:00:00 | 2 | 1 | 1
12 | MURGATROYD | PAUL | PW340651D | 2010-08-05 00:00:00 | 12 | 1 | 1
13 | MURPHY | ANTHONY | WM201679A | 2010-08-05 00:00:00 | 1 | 1 | 1
14 | NEILD | [NAME] | YX944208A | 2010-08-05 00:00:00 | 1 | 1 | 1
15 | [NAME] | [NAME] | NR287433C | 2010-08-05 00:00:00 | 68 | 1 | 1
16 | ORANGE | SARA | JE560845B | 2010-08-05 00:00:00 | 4 | 2 | 1
17 | O'TOOLE | PAULINE | JA767369B | 2010-08-05 00:00:00 | 17 | 2 | 1
18 | PATTERSON | PETER | NW535726C | 2010-08-05 00:00:00 | 112 | 2 | 1
19 | POWELL | [NAME] | YT449031D | 2010-08-05 00:00:00 | 24 | 2 | 1
20 | RATCLIFFE | CARISSA | PX999701B | 2010-08-05 00:00:00 | 12 | 2 | 1
21 | REDDOCK | [NAME] | WL279301B | 2010-08-05 00:00:00 | 78 | 2 | 1
22 | [NAME] | STEPHANIE | JZ619082C | 2010-08-05 00:00:00 | 8 | 2 | 1
23 | RICHARDSON | JENNA | JK933163D | 2010-08-05 00:00:00 | 3 | 2 | 1
24 | [NAME] | MARGARET | YB449154C | 2010-08-05 00:00:00 | 1 | 2 | 1
25 | ROBINETTE | PAMELA | NS334846D | 2010-08-05 00:00:00 | 6 | 2 | 1
26 | [NAME] | SAMANTHA | JG518110C | 2010-08-05 00:00:00 | 7 | 2 | 1
27 | SAMPSON | [NAME] | JH368294C | 2010-08-05 00:00:00 | 31 | 2 | 1
28 | SHARPLES | SHARON | NH021438D | 2010-08-05 00:00:00 | 4 | 2 | 1
29 | SKILKY | JENNIFER | JS761697B | 2010-08-05 00:00:00 | 8 | 2 | 1
30 | BOSTON | [NAME] | JH258157B | 2010-08-05 00:00:00 | 34 | 2 | 1
31 | SMITH | PHILIP | WA741626A | 2010-08-05 00:00:00 | 2 | 3 | 1
32 | SMITH | WILLIAM | NA121944A | 2010-08-05 00:00:00 | 9 | 3 | 1
33 | SMITH | NAOMI | WP065011A | 2010-08-05 00:00:00 | 51 | 3 | 1
34 | SMITH | WILSON | JE653514C | 2010-08-05 00:00:00 | 35 | 3 | 1
35 | SMITHURST | SHARON | NH090419B | 2010-08-05 00:00:00 | 1 | 3 | 1
36 | STANLEY | [NAME] | WE963186A | 2010-08-05 00:00:00 | 2 | 3 | 1
37 | STANSFIELD | [NAME] | PW306268A | 2010-08-05 00:00:00 | 41 | 3 | 1
38 | STEVENSON | IRENE | NX502533B | 2010-08-05 00:00:00 | 41 | 3 | 1
39 | TAYLOR | [NAME] | JS466668A | 2010-08-05 00:00:00 | 32 | 3 | 1
40 | TURNER | NICOLA | JG208609B | 2010-08-05 00:00:00 | 75 | 3 | 1
41 | WARDIL | JODIE | [NAME] | 2010-08-05 00:00:00 | 4 | 3 | 1
42 | WATSON | ALBERT | ZW991870B | 2010-08-05 00:00:00 | 2 | 3 | 1
43 | WAUGH | CARL | JN940535D | 2010-08-05 00:00:00 | 4 | 3 | 1
44 | WELSH | [NAME] | JW938585B | 2010-08-05 00:00:00 | 4 | 3 | 1
45 | WYNTER | AMY | JR079468A | 2010-08-05 00:00:00 | 12 | 3 | 1
46 | CANTLIE | KELLY | JP839606C | 2010-08-05 00:00:00 | 14 | 4 | 1
47 | ALLEN | GEMMA | [NAME] | 2010-08-05 00:00:00 | 5 | 4 | 1
48 | ARMSTRONG | PAUL | [NAME] | 2010-08-05 00:00:00 | 117 | 4 | 1
49 | BARKER | [NAME] | NB547633B | 2010-08-05 00:00:00 | 109 | 4 | 1
50 | BARNES | KATIE | JR907825B | 2010-08-05 00:00:00 | 3 | 4 | 1
51 | BRADBURY | LYNSEY | JP413209B | 2010-08-05 00:00:00 | 45 | 4 | 1
52 | BRADLEY | THOMAS | JM747360A | 2010-08-05 00:00:00 | 73 | 4 | 1
53 | BURTON | CHRISTINA | WK385163C | 2010-08-05 00:00:00 | 1 | 4 | 1
54 | BUSHELL | LOUISE | [NAME] | 2010-08-05 00:00:00 | 14 | 4 | 1
55 | CANN | KENNETH | YY637382B | 2010-08-05 00:00:00 | 67 | 4 | 1
56 | CATLOW | PETER | YX596882D | 2010-08-05 00:00:00 | 7 | 5 | 1
57 | CHAPPLE | [NAME] | YR664153A | 2010-08-05 00:00:00 | 2 | 5 | 1
58 | CHEGWIN | EDITH | YP487280D | 2010-08-05 00:00:00 | 25 | 5 | 1
59 | COOKER | EDITH | NA807647A | 2010-08-05 00:00:00 | 15 | 5 | 1
60 | COLLINS | DANIEL | YW675474C | 2010-08-05 00:00:00 | 9 | 5 | 1
61 | DAVIES | SANDRA | [NAME] | 2010-08-05 00:00:00 | 66 | 5 | 1
62 | DEACON | HAYLEY | [NAME] | 2010-08-05 00:00:00 | 113 | 5 | 1
63 | DEMPSEY | PATRICK | WA813697B | 2010-08-05 00:00:00 | 28 | 5 | 1
64 | DICKINSON | [NAME] | JR452496A | 2010-08-05 00:00:00 | 9 | 5 | 1
65 | DODD | KATHLEEN | NX438946C | 2010-08-05 00:00:00 | 1 | 5 | 1
66 | DOWLING | [NAME] | PW807946C | 2010-08-05 00:00:00 | 18 | 5 | 1
67 | LONGMAN | RAYMOND | WE020926D | 2010-08-05 00:00:00 | 7 | 5 | 1
68 | LYNCH | [NAME] | JC964969B | 2010-08-05 00:00:00 | 52 | 5 | 1
69 | VAUGHAN | MARK | NZ094304B | 2010-08-05 00:00:00 | 29 | 5 | 1
70 | WATSON | FRANK | YK852906B | 2010-08-05 00:00:00 | 1 | 5 | 1
71 | FEENEY | FRANCIS | WL346062A | 2010-08-05 00:00:00 | 51 | 6 | 1
72 | FLYNN | [NAME] | JT583865B | 2010-08-05 00:00:00 | 3 | 6 | 1
73 | GAFFNEY | CLAIRE | [NAME] | 2010-08-05 00:00:00 | 51 | 6 | 1
74 | HARRISON | ZOE | [NAME] | 2010-08-05 00:00:00 | 23 | 6 | 1
75 | IRELAND | [NAME] | YX223693B | 2010-08-05 00:00:00 | 5 | 6 | 1
76 | JONES | SUSAN | NM599616B | 2010-08-05 00:00:00 | 49 | 6 | 1
77 | JONES | TONI | JK726835D | 2010-08-05 00:00:00 | 3 | 6 | 1
78 | KINSON | [NAME] | NB791162B | 2010-08-05 00:00:00 | 24 | 6 | 1
79 | LAFFERTY | CHRISTOPHER | [NAME] | 2010-08-05 00:00:00 | 13 | 6 | 1
80 | LATHAM | PETER | NE425417C | 2010-08-05 00:00:00 | 6 | 6 | 1
81 | LEIGH | KAYLEY | JP042360A | 2010-08-05 00:00:00 | 21 | 6 | 1
82 | LEWIS | BERNADETTE | [NAME] | 2010-08-05 00:00:00 | 64 | 6 | 1
83 | LEWIS | SUSAN | YY460994A | 2010-08-05 00:00:00 | 50 | 6 | 1
84 | LITHERLAND | MARK | JR401005B | 2010-08-05 00:00:00 | 47 | 6 | 1
85 | LOMAX | JAY | JS088110C | 2010-08-05 00:00:00 | 38 | 6 | 1
86 | MANGAN | STELLA | YT578016C | 2010-08-05 00:00:00 | 74 | 7 | 1
87 | MARTIN | MARGERY | ZY801603D | 2010-08-05 00:00:00 | 23 | 7 | 1
88 | MELLING | ANTHONY | YB250973C | 2010-08-05 00:00:00 | 24 | 7 | 1
89 | OMER | NAHED | SC751205B | 2010-08-05 00:00:00 | 15 | 7 | 1
90 | OWENS | KRISTINA | [NAME] | 2010-08-05 00:00:00 | 77 | 7 | 1
91 | PARRY | [NAME] | YL794367A | 2010-08-05 00:00:00 | 22 | 7 | 1
92 | PITTARD | CHRISTINA | NS366511A | 2010-08-05 00:00:00 | 12 | 7 | 1
93 | QALIB | ISSE | SK392906C | 2010-08-05 00:00:00 | 4 | 7 | 1
94 | REDGRIFT | DARREN | NR369293D | 2010-08-05 00:00:00 | 2 | 7 | 1
95 | RIGBY | ALISON | NZ795787C | 2010-08-05 00:00:00 | 1 | 7 | 1
96 | ROWAN | CARMEN | JN739309B | 2010-08-05 00:00:00 | 13 | 7 | 1
97 | ROWAN | [NAME] | JN739310C | 2010-08-05 00:00:00 | 12 | 7 | 1
98 | SHAW | [NAME] | NW241633C | 2010-08-05 00:00:00 | 49 | 7 | 1
99 | SMITH | MARK | JP615923D | 2010-08-05 00:00:00 | 43 | 7 | 1
100 | SPURRIER | JEANETTE | NZ187153C | 2010-08-05 00:00:00 | 1 | 7 | 1
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202