Find Cell in row, check conditions of two cells and change cell format in other sheet

T

The Chad

New Member
Joined
Oct 17, 2011
Messages
26
Hi all,
I am slowly progressing with my workbook , but have now been stuck for the past day working out a solution that will match/find a cell that has a unique id in one sheet with a second sheet then go back to the original sheet and find/match a training module identifier in the second sheet. It needs to be on the same row as the unique identifier.

The cell will need to change colour to represent that the training module has been completed.
Original Sheet is identified as “Trg Data WS”
Second sheet is identified as “Status WS"
Status WS below
<table class="MsoNormalTable" style="width:617.0pt;margin-left:4.9pt;border-collapse:collapse;mso-yfti-tbllook: 1184;mso-padding-alt:0cm 5.4pt 0cm 5.4pt" border="0" cellpadding="0" cellspacing="0" width="823"> <tbody><tr style="mso-yfti-irow:0;mso-yfti-firstrow:yes;height:12.75pt"> <td style="width:48.0pt;border:solid windowtext 1.0pt; mso-border-top-alt:1.0pt;mso-border-left-alt:1.0pt;mso-border-bottom-alt: .5pt;mso-border-right-alt:.5pt;mso-border-color-alt:windowtext;mso-border-style-alt: solid;background:silver;padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="64"> [FONT=&quot]Occ[/FONT]
</td> <td style="width:50.0pt;border:solid windowtext 1.0pt; border-left:none;mso-border-top-alt:solid windowtext 1.0pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;background: silver;padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="67"> [FONT=&quot]Occ name[/FONT]
</td> <td style="width:46.0pt;border:solid windowtext 1.0pt; border-left:none;mso-border-top-alt:solid windowtext 1.0pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;background: silver;padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="61"> [FONT=&quot]Cost Cen[/FONT]
</td> <td style="width:26.0pt;border:solid windowtext 1.0pt; border-left:none;mso-border-top-alt:solid windowtext 1.0pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;background: silver;padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="35"> [FONT=&quot]Org#[/FONT]
</td> <td style="width:48.0pt;border:solid windowtext 1.0pt; border-left:none;mso-border-top-alt:solid windowtext 1.0pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;background: silver;padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="64"> [FONT=&quot]Org name[/FONT]
</td> <td style="width:70.0pt;border:solid windowtext 1.0pt; border-left:none;mso-border-top-alt:solid windowtext 1.0pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;background: silver;padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="93"> [FONT=&quot]R-AB-1109-OL[/FONT]
</td> <td style="width:70.0pt;border:solid windowtext 1.0pt; border-left:none;mso-border-top-alt:solid windowtext 1.0pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;background: silver;padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="93"> [FONT=&quot]R-AC-1110-OL[/FONT]
</td> <td style="width:63.0pt;border:solid windowtext 1.0pt; border-left:none;mso-border-top-alt:solid windowtext 1.0pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;background: silver;padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="84"> [FONT=&quot]R-AC-1112-S[/FONT]
</td> <td style="width:70.0pt;border:solid windowtext 1.0pt; border-left:none;mso-border-top-alt:solid windowtext 1.0pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;background: silver;padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="93"> [FONT=&quot]R-EA-1126-OL[/FONT]
</td> <td style="width:63.0pt;border:solid windowtext 1.0pt; border-left:none;mso-border-top-alt:solid windowtext 1.0pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;background: silver;padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="84"> [FONT=&quot]R-EA-1150-C[/FONT]
</td> <td style="width:63.0pt;border:solid windowtext 1.0pt; border-left:none;mso-border-top-alt:solid windowtext 1.0pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt;background: silver;padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="84"> [FONT=&quot]R-FG-1151-C[/FONT]
</td> </tr> <tr style="mso-yfti-irow:1;height:12.75pt"> <td style="width:48.0pt;border:solid windowtext 1.0pt; border-top:none;mso-border-left-alt:solid windowtext 1.0pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding: 0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="64"> [FONT=&quot]1[/FONT]
</td> <td style="width:50.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="67"> [FONT=&quot]John[/FONT]
</td> <td style="width:46.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="61"> [FONT=&quot]11111[/FONT]
</td> <td style="width:26.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="35"> [FONT=&quot]123[/FONT]
</td> <td style="width:48.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="64"> [FONT=&quot]ABC[/FONT]
</td> <td style="width:70.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="93">
[FONT=&quot]0[/FONT]​
</td> <td style="width:70.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:#FF9900;padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="93"> [FONT=&quot]R-AC-1110-OL[/FONT]
</td> <td style="width:63.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:#FF9900;padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="84"> [FONT=&quot]R-AC-1112-S[/FONT]
</td> <td style="width:70.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="93">
[FONT=&quot]0[/FONT]​
</td> <td style="width:63.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:#FF9900;padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="84"> [FONT=&quot]R-EA-1150-C[/FONT]
</td> <td style="width:63.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="84">
[FONT=&quot]0[/FONT]​
</td> </tr> <tr style="mso-yfti-irow:2;height:12.75pt"> <td style="width:48.0pt;border:solid windowtext 1.0pt; border-top:none;mso-border-left-alt:solid windowtext 1.0pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding: 0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="64"> [FONT=&quot]2[/FONT]
</td> <td style="width:50.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="67"> [FONT=&quot]Joe[/FONT]
</td> <td style="width:46.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="61"> [FONT=&quot]11111[/FONT]
</td> <td style="width:26.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="35"> [FONT=&quot]145[/FONT]
</td> <td style="width:48.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="64"> [FONT=&quot]ABC[/FONT]
</td> <td style="width:70.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="93">
[FONT=&quot]0[/FONT]​
</td> <td style="width:70.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:#FF9900;padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="93"> [FONT=&quot]R-AC-1110-OL[/FONT]
</td> <td style="width:63.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:#FF9900;padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="84"> [FONT=&quot]R-AC-1112-S[/FONT]
</td> <td style="width:70.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="93">
[FONT=&quot]0[/FONT]​
</td> <td style="width:63.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:#FF9900;padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="84"> [FONT=&quot]R-EA-1150-C[/FONT]
</td> <td style="width:63.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="84">
[FONT=&quot]0[/FONT]​
</td> </tr> <tr style="mso-yfti-irow:3;height:12.75pt"> <td style="width:48.0pt;border:solid windowtext 1.0pt; border-top:none;mso-border-left-alt:solid windowtext 1.0pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding: 0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="64"> [FONT=&quot]234[/FONT]
</td> <td style="width:50.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="67"> [FONT=&quot]Jane[/FONT]
</td> <td style="width:46.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="61"> [FONT=&quot]22222[/FONT]
</td> <td style="width:26.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="35"> [FONT=&quot]199[/FONT]
</td> <td style="width:48.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="64"> [FONT=&quot]ABC[/FONT]
</td> <td style="width:70.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="93">
[FONT=&quot]0[/FONT]​
</td> <td style="width:70.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="93">
[FONT=&quot]0[/FONT]​
</td> <td style="width:63.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="84">
[FONT=&quot]0[/FONT]​
</td> <td style="width:70.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="93">
[FONT=&quot]0[/FONT]​
</td> <td style="width:63.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="84">
[FONT=&quot]0[/FONT]​
</td> <td style="width:63.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="84">
[FONT=&quot]0[/FONT]​
</td> </tr> <tr style="mso-yfti-irow:4;height:12.75pt"> <td style="width:48.0pt;border:solid windowtext 1.0pt; border-top:none;mso-border-left-alt:solid windowtext 1.0pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding: 0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="64"> [FONT=&quot]5467[/FONT]
</td> <td style="width:50.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="67"> [FONT=&quot]Jim[/FONT]
</td> <td style="width:46.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="61"> [FONT=&quot]33333[/FONT]
</td> <td style="width:26.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="35"> [FONT=&quot]299[/FONT]
</td> <td style="width:48.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="64"> [FONT=&quot]GHI[/FONT]
</td> <td style="width:70.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="93">
[FONT=&quot]0[/FONT]​
</td> <td style="width:70.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:#FF9900;padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="93"> [FONT=&quot]R-AC-1110-OL[/FONT]
</td> <td style="width:63.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:#FF9900;padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="84"> [FONT=&quot]R-AC-1112-S[/FONT]
</td> <td style="width:70.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="93">
[FONT=&quot]0[/FONT]​
</td> <td style="width:63.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:#FF9900;padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="84"> [FONT=&quot]R-EA-1150-C[/FONT]
</td> <td style="width:63.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="84">
[FONT=&quot]0[/FONT]​
</td> </tr> <tr style="mso-yfti-irow:5;height:12.75pt"> <td style="width:48.0pt;border:solid windowtext 1.0pt; border-top:none;mso-border-left-alt:solid windowtext 1.0pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding: 0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="64"> [FONT=&quot]1111[/FONT]
</td> <td style="width:50.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="67"> [FONT=&quot]Jill[/FONT]
</td> <td style="width:46.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="61"> [FONT=&quot]22222[/FONT]
</td> <td style="width:26.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="35"> [FONT=&quot]199[/FONT]
</td> <td style="width:48.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="64"> [FONT=&quot]DEF[/FONT]
</td> <td style="width:70.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:#FF9900;padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="93"> [FONT=&quot]R-AB-1109-OL[/FONT]
</td> <td style="width:70.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="93">
[FONT=&quot]0[/FONT]​
</td> <td style="width:63.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="84">
[FONT=&quot]0[/FONT]​
</td> <td style="width:70.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="93">
[FONT=&quot]0[/FONT]​
</td> <td style="width:63.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="84">
[FONT=&quot]0[/FONT]​
</td> <td style="width:63.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt; background:#FF9900;padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="84"> [FONT=&quot]R-FG-1151-C[/FONT]
</td> </tr> <tr style="mso-yfti-irow:6;height:12.75pt"> <td style="width:48.0pt;border:solid windowtext 1.0pt; border-top:none;mso-border-left-alt:solid windowtext 1.0pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding: 0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="64"> [FONT=&quot]87[/FONT]
</td> <td style="width:50.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="67"> [FONT=&quot]Jeremy[/FONT]
</td> <td style="width:46.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="61"> [FONT=&quot]33333[/FONT]
</td> <td style="width:26.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="35"> [FONT=&quot]227[/FONT]
</td> <td style="width:48.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="64"> [FONT=&quot]GHI[/FONT]
</td> <td style="width:70.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:#FF9900;padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="93"> [FONT=&quot]R-AB-1109-OL[/FONT]
</td> <td style="width:70.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="93">
[FONT=&quot]0[/FONT]​
</td> <td style="width:63.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="84">
[FONT=&quot]0[/FONT]​
</td> <td style="width:70.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="93">
[FONT=&quot]0[/FONT]​
</td> <td style="width:63.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="84">
[FONT=&quot]0[/FONT]​
</td> <td style="width:63.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt; background:#FF9900;padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="84"> [FONT=&quot]R-FG-1151-C[/FONT]
</td> </tr> <tr style="mso-yfti-irow:7;mso-yfti-lastrow:yes;height:13.5pt"> <td style="width:48.0pt;border:solid windowtext 1.0pt; border-top:none;mso-border-left-alt:solid windowtext 1.0pt;mso-border-bottom-alt: solid windowtext 1.0pt;mso-border-right-alt:solid windowtext .5pt;padding: 0cm 5.4pt 0cm 5.4pt;height:13.5pt" nowrap="nowrap" valign="bottom" width="64"> [FONT=&quot]15432[/FONT]
</td> <td style="width:50.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext 1.0pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt" nowrap="nowrap" valign="bottom" width="67"> [FONT=&quot]Jack[/FONT]
</td> <td style="width:46.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext 1.0pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt" nowrap="nowrap" valign="bottom" width="61"> [FONT=&quot]11111[/FONT]
</td> <td style="width:26.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext 1.0pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt" nowrap="nowrap" valign="bottom" width="35"> [FONT=&quot]123[/FONT]
</td> <td style="width:48.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext 1.0pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt" nowrap="nowrap" valign="bottom" width="64"> [FONT=&quot]ABC[/FONT]
</td> <td style="width:70.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext 1.0pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt" nowrap="nowrap" valign="bottom" width="93">
[FONT=&quot]0[/FONT]​
</td> <td style="width:70.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext 1.0pt;mso-border-right-alt:solid windowtext .5pt; background:#FF9900;padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt" nowrap="nowrap" valign="bottom" width="93"> [FONT=&quot]R-AC-1110-OL[/FONT]
</td> <td style="width:63.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext 1.0pt;mso-border-right-alt:solid windowtext .5pt; background:#FF9900;padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt" nowrap="nowrap" valign="bottom" width="84"> [FONT=&quot]R-AC-1112-S[/FONT]
</td> <td style="width:70.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext 1.0pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt" nowrap="nowrap" valign="bottom" width="93">
[FONT=&quot]0[/FONT]​
</td> <td style="width:63.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext 1.0pt;mso-border-right-alt:solid windowtext .5pt; background:#FF9900;padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt" nowrap="nowrap" valign="bottom" width="84"> [FONT=&quot]R-EA-1150-C[/FONT]
</td> <td style="width:63.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt" nowrap="nowrap" valign="bottom" width="84">
[FONT=&quot]0[/FONT]​
</td> </tr> </tbody> </table>

The orange cell colour is an identifier that a training module has been assigned to a person. The aim is to get it to turn green if a person has completed the training module.


The “0” I do not need to worry about as I am only interested in the training modules assigned to people.

Trg Data WS below
<table class="MsoNormalTable" style="width:419.0pt;margin-left:4.9pt;border-collapse:collapse;mso-yfti-tbllook: 1184;mso-padding-alt:0cm 5.4pt 0cm 5.4pt" border="0" cellpadding="0" cellspacing="0" width="559"> <tbody><tr style="mso-yfti-irow:0;mso-yfti-firstrow:yes;height:12.75pt"> <td style="width:48.0pt;border:solid windowtext 1.0pt; mso-border-top-alt:1.0pt;mso-border-left-alt:1.0pt;mso-border-bottom-alt: .5pt;mso-border-right-alt:.5pt;mso-border-color-alt:windowtext;mso-border-style-alt: solid;background:silver;padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="64"> [FONT=&quot]Attendee[/FONT]
</td> <td style="width:50.0pt;border:solid windowtext 1.0pt; border-left:none;mso-border-top-alt:solid windowtext 1.0pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;background: silver;padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="67"> [FONT=&quot]Occ name[/FONT]
</td> <td style="width:46.0pt;border:solid windowtext 1.0pt; border-left:none;mso-border-top-alt:solid windowtext 1.0pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;background: silver;padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="61"> [FONT=&quot]Cost Cen[/FONT]
</td> <td style="width:26.0pt;border:solid windowtext 1.0pt; border-left:none;mso-border-top-alt:solid windowtext 1.0pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;background: silver;padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="35"> [FONT=&quot]Org#[/FONT]
</td> <td style="width:48.0pt;border:solid windowtext 1.0pt; border-left:none;mso-border-top-alt:solid windowtext 1.0pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;background: silver;padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="64"> [FONT=&quot]Org name[/FONT]
</td> <td style="width:70.0pt;border:solid windowtext 1.0pt; border-left:none;mso-border-top-alt:solid windowtext 1.0pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;background: silver;padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="93"> [FONT=&quot]Object ID[/FONT]
</td> <td style="width:131.0pt;border:solid windowtext 1.0pt; border-left:none;mso-border-top-alt:solid windowtext 1.0pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt;background: silver;padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="175"> [FONT=&quot]Abbreviation Business Event[/FONT]
</td> </tr> <tr style="mso-yfti-irow:1;height:12.75pt"> <td style="width:48.0pt;border:solid windowtext 1.0pt; border-top:none;mso-border-left-alt:solid windowtext 1.0pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding: 0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="64">
[FONT=&quot]1[/FONT]​
</td> <td style="width:50.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="67"> [FONT=&quot]John[/FONT]
</td> <td style="width:46.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="61"> [FONT=&quot]11111[/FONT]
</td> <td style="width:26.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="35"> [FONT=&quot]123[/FONT]
</td> <td style="width:48.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="64"> [FONT=&quot]ABC[/FONT]
</td> <td style="width:70.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="93"> [FONT=&quot]NA[/FONT]
</td> <td style="width:131.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="175"> [FONT=&quot]R-AO-0230-OL[/FONT]
</td> </tr> <tr style="mso-yfti-irow:2;height:12.75pt"> <td style="width:48.0pt;border:solid windowtext 1.0pt; border-top:none;mso-border-left-alt:solid windowtext 1.0pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding: 0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="64">
[FONT=&quot]1[/FONT]​
</td> <td style="width:50.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="67"> [FONT=&quot]John[/FONT]
</td> <td style="width:46.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="61"> [FONT=&quot]11111[/FONT]
</td> <td style="width:26.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="35"> [FONT=&quot]123[/FONT]
</td> <td style="width:48.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="64"> [FONT=&quot]ABC[/FONT]
</td> <td style="width:70.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="93"> [FONT=&quot]NA[/FONT]
</td> <td style="width:131.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="175"> [FONT=&quot]R-AO-0240-OL[/FONT]
</td> </tr> <tr style="mso-yfti-irow:3;height:12.75pt"> <td style="width:48.0pt;border:solid windowtext 1.0pt; border-top:none;mso-border-left-alt:solid windowtext 1.0pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding: 0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="64">
[FONT=&quot]2[/FONT]​
</td> <td style="width:50.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="67"> [FONT=&quot]Joe[/FONT]
</td> <td style="width:46.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="61"> [FONT=&quot]11111[/FONT]
</td> <td style="width:26.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="35"> [FONT=&quot]145[/FONT]
</td> <td style="width:48.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="64"> [FONT=&quot]ABC[/FONT]
</td> <td style="width:70.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="93"> [FONT=&quot]NA[/FONT]
</td> <td style="width:131.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="175"> [FONT=&quot]R-EM-0410-OL[/FONT]
</td> </tr> <tr style="mso-yfti-irow:4;height:12.75pt"> <td style="width:48.0pt;border:solid windowtext 1.0pt; border-top:none;mso-border-left-alt:solid windowtext 1.0pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding: 0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="64">
[FONT=&quot]234[/FONT]​
</td> <td style="width:50.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="67"> [FONT=&quot]Jane[/FONT]
</td> <td style="width:46.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="61">
[FONT=&quot]22222[/FONT]​
</td> <td style="width:26.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="35"> [FONT=&quot]199[/FONT]
</td> <td style="width:48.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="64"> [FONT=&quot]ABC[/FONT]
</td> <td style="width:70.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="93"> [FONT=&quot]NA[/FONT]
</td> <td style="width:131.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="175"> [FONT=&quot]R-EQ-0550-OL[/FONT]
</td> </tr> <tr style="mso-yfti-irow:5;height:12.75pt"> <td style="width:48.0pt;border:solid windowtext 1.0pt; border-top:none;mso-border-left-alt:solid windowtext 1.0pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding: 0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="64">
[FONT=&quot]5467[/FONT]​
</td> <td style="width:50.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="67"> [FONT=&quot]Jim[/FONT]
</td> <td style="width:46.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="61">
[FONT=&quot]33333[/FONT]​
</td> <td style="width:26.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="35"> [FONT=&quot]299[/FONT]
</td> <td style="width:48.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="64"> [FONT=&quot]GHI[/FONT]
</td> <td style="width:70.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="93"> [FONT=&quot]NA[/FONT]
</td> <td style="width:131.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="175"> [FONT=&quot]R-HF-0750-OL[/FONT]
</td> </tr> <tr style="mso-yfti-irow:6;height:12.75pt"> <td style="width:48.0pt;border:solid windowtext 1.0pt; border-top:none;mso-border-left-alt:solid windowtext 1.0pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding: 0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="64">
[FONT=&quot]5467[/FONT]​
</td> <td style="width:50.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="67"> [FONT=&quot]Jim[/FONT]
</td> <td style="width:46.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="61">
[FONT=&quot]33333[/FONT]​
</td> <td style="width:26.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="35"> [FONT=&quot]299[/FONT]
</td> <td style="width:48.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="64"> [FONT=&quot]GHI[/FONT]
</td> <td style="width:70.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="93"> [FONT=&quot]NA[/FONT]
</td> <td style="width:131.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="175"> [FONT=&quot]R-EM-0470-OL[/FONT]
</td> </tr> <tr style="mso-yfti-irow:7;height:12.75pt"> <td style="width:48.0pt;border:solid windowtext 1.0pt; border-top:none;mso-border-left-alt:solid windowtext 1.0pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding: 0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="64">
[FONT=&quot]1111[/FONT]​
</td> <td style="width:50.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="67"> [FONT=&quot]Jill[/FONT]
</td> <td style="width:46.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="61">
[FONT=&quot]22222[/FONT]​
</td> <td style="width:26.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="35"> [FONT=&quot]199[/FONT]
</td> <td style="width:48.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="64"> [FONT=&quot]DEF[/FONT]
</td> <td style="width:70.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="93"> [FONT=&quot]NA[/FONT]
</td> <td style="width:131.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="175"> [FONT=&quot]R-AB-1109-OL[/FONT]
</td> </tr> <tr style="mso-yfti-irow:8;height:12.75pt"> <td style="width:48.0pt;border:solid windowtext 1.0pt; border-top:none;mso-border-left-alt:solid windowtext 1.0pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding: 0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="64">
[FONT=&quot]87[/FONT]​
</td> <td style="width:50.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="67"> [FONT=&quot]Jeremy[/FONT]
</td> <td style="width:46.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="61"> [FONT=&quot]33333[/FONT]
</td> <td style="width:26.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="35"> [FONT=&quot]227[/FONT]
</td> <td style="width:48.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="64"> [FONT=&quot]GHI[/FONT]
</td> <td style="width:70.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="93"> [FONT=&quot]NA[/FONT]
</td> <td style="width:131.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="175"> [FONT=&quot]R-AB-1109-OL[/FONT]
</td> </tr> <tr style="mso-yfti-irow:9;height:12.75pt"> <td style="width:48.0pt;border:solid windowtext 1.0pt; border-top:none;mso-border-left-alt:solid windowtext 1.0pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding: 0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="64">
[FONT=&quot]87[/FONT]​
</td> <td style="width:50.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="67"> [FONT=&quot]Jeremy[/FONT]
</td> <td style="width:46.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="61"> [FONT=&quot]33333[/FONT]
</td> <td style="width:26.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="35"> [FONT=&quot]227[/FONT]
</td> <td style="width:48.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="64"> [FONT=&quot]GHI[/FONT]
</td> <td style="width:70.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="93"> [FONT=&quot]NA[/FONT]
</td> <td style="width:131.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt;height:12.75pt" nowrap="nowrap" valign="bottom" width="175"> [FONT=&quot]R-FG-1151-C[/FONT]
</td> </tr> <tr style="mso-yfti-irow:10;mso-yfti-lastrow:yes;height:13.5pt"> <td style="width:48.0pt;border:solid windowtext 1.0pt; border-top:none;mso-border-left-alt:solid windowtext 1.0pt;mso-border-bottom-alt: solid windowtext 1.0pt;mso-border-right-alt:solid windowtext .5pt;padding: 0cm 5.4pt 0cm 5.4pt;height:13.5pt" nowrap="nowrap" valign="bottom" width="64">
[FONT=&quot]15432[/FONT]​
</td> <td style="width:50.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext 1.0pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt" nowrap="nowrap" valign="bottom" width="67"> [FONT=&quot]Jack[/FONT]
</td> <td style="width:46.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext 1.0pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt" nowrap="nowrap" valign="bottom" width="61"> [FONT=&quot]11111[/FONT]
</td> <td style="width:26.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext 1.0pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt" nowrap="nowrap" valign="bottom" width="35"> [FONT=&quot]123[/FONT]
</td> <td style="width:48.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext 1.0pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt" nowrap="nowrap" valign="bottom" width="64"> [FONT=&quot]ABC[/FONT]
</td> <td style="width:70.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext 1.0pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt" nowrap="nowrap" valign="bottom" width="93"> [FONT=&quot]NA[/FONT]
</td> <td style="width:131.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt" nowrap="nowrap" valign="bottom" width="175"> [FONT=&quot]R-EA-1150-C[/FONT]
</td> </tr> </tbody> </table>
“Occupant” and “Attendee ID “ are the same

I have excluded some columns to make it easier to see, as there are 47 different training modules and approx 1000 people in "Status WS" who have completed approx 4500 training modules in "Trg Data WS".

I have really struggled with coding the macro and am just getting myself confused. FWIW the code I have at the moment is below but has a couple of if statements in that will not work as I am just looking at how to go about finding a suitable way to move forward.
Code: 
Sub FindMatchTwoConditionsNo2()
   'this is work in progress
   'code morphed from "shg"
   Dim i, j, lRow
   Dim rFind As Range
   Dim vWhat As Variant
    
   With Application
       .ScreenUpdating = False
       .EnableEvents = False
       .Calculation = xlCalculationManual
   End With
           lRow = Range("A" & Rows.Count).End(xlUp).Row
           For i = lRow To 2 Step -1
               Set rFind=Sheet('Status WS'!"A:A") _’still need to look at this
                   .Find(What:=vWhat,LookIn:=xlValues,LookAt:=xlWhole, MatchByte:=False)
               If Range ("A" & i) = rFind & Range"E" & i) = 'the data is in several columns
               then
               
               If Not rFind Is Nothing Then
                   'need to search on row in "Status WS" to find matching cell value to change colour
                      
            End If
           Next i
       Next j
       
   With Application
       .ScreenUpdating = True
       .EnableEvents = True
       .Calculation = xlCalculationAutomatic
   End With
   End Sub
Any ideas are welcome as usual.
Cheers,
Chad
 
You must log in or register to reply here.

Similar threads

D
  • Solved
VBA Function to Paste Table into Outlook Email Resulting in HTML language in Email
Replies
8
Views
918
smozgur
smozgur
A
  • Question Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
3K
Attrazion
A
D
  • Question Question
How to output a dynamic range where the height of the range varies
Replies
0
Views
1K
dagda13
D
B
  • Question Question
Appending a Value to Each Element of a Range Array
Replies
7
Views
2K
Peter_SSs
Peter_SSs
E
  • Solved
Match sets of values
Replies
9
Views
1K
Akuini
Akuini

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top