Keeping two tables equal based on header column

Cyclops755

New Member
Joined
Jul 26, 2011
Messages
31
I've got two tables A & B on seperate sheets that I need to keep equal based on their header column. In other words:

A
<table style="width: 380px; height: 160px;" border="0" cellpadding="0" cellspacing="0"><colgroup><col style="mso-width-source:userset;mso-width-alt:2779; width:57pt" span="5" width="76"> </colgroup><tbody><tr style="height:15.0pt" height="20"> <td style="height:15.0pt;width:57pt;font-size:11.0pt; color:white;font-weight:700;text-decoration:none;text-underline-style:none; text-line-through:none;font-family:Calibri;border-top:none;border-right:.5pt solid white; border-bottom:1.5pt solid white;border-left:none;background:#4F81BD; mso-pattern:#4F81BD none" height="20" width="76">Column1</td> <td style="width:57pt;font-size:11.0pt;color:white;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:none;border-right:.5pt solid white;border-bottom: 1.5pt solid white;border-left:none;background:#4F81BD;mso-pattern:#4F81BD none" width="76">Column2</td> <td style="width:57pt;font-size:11.0pt;color:white;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:none;border-right:.5pt solid white;border-bottom: 1.5pt solid white;border-left:none;background:#4F81BD;mso-pattern:#4F81BD none" width="76">Column3</td> <td style="width:57pt;font-size:11.0pt;color:white;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:none;border-right:.5pt solid white;border-bottom: 1.5pt solid white;border-left:none;background:#4F81BD;mso-pattern:#4F81BD none" width="76">Column4</td> <td style="width:57pt;font-size:11.0pt;color:white;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:none;border-right:none;border-bottom:1.5pt solid white; border-left:none;background:#4F81BD;mso-pattern:#4F81BD none" width="76">Column5</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt;font-size:11.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:Calibri;border-top:none;border-right:.5pt solid white; border-bottom:.5pt solid white;border-left:none;background:#B8CCE4; mso-pattern:#B8CCE4 none" align="right" height="20">1</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#B8CCE4;mso-pattern:#B8CCE4 none">x</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#B8CCE4;mso-pattern:#B8CCE4 none">
</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#B8CCE4;mso-pattern:#B8CCE4 none">
</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:none;border-bottom:.5pt solid white;border-left: none;background:#B8CCE4;mso-pattern:#B8CCE4 none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt;font-size:11.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:Calibri;border-top:none;border-right:.5pt solid white; border-bottom:.5pt solid white;border-left:none;background:#DBE5F1; mso-pattern:#DBE5F1 none" align="right" height="20">2</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#DBE5F1;mso-pattern:#DBE5F1 none">
</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#DBE5F1;mso-pattern:#DBE5F1 none">x</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#DBE5F1;mso-pattern:#DBE5F1 none">x</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:none;border-bottom:.5pt solid white;border-left: none;background:#DBE5F1;mso-pattern:#DBE5F1 none">x</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt;font-size:11.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:Calibri;border-top:none;border-right:.5pt solid white; border-bottom:.5pt solid white;border-left:none;background:#B8CCE4; mso-pattern:#B8CCE4 none" align="right" height="20">3</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#B8CCE4;mso-pattern:#B8CCE4 none">
</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#B8CCE4;mso-pattern:#B8CCE4 none">
</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#B8CCE4;mso-pattern:#B8CCE4 none">x</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:none;border-bottom:.5pt solid white;border-left: none;background:#B8CCE4;mso-pattern:#B8CCE4 none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt;font-size:11.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:Calibri;border-top:none;border-right:.5pt solid white; border-bottom:.5pt solid white;border-left:none;background:#DBE5F1; mso-pattern:#DBE5F1 none" align="right" height="20">4</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#DBE5F1;mso-pattern:#DBE5F1 none">x</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#DBE5F1;mso-pattern:#DBE5F1 none">x</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#DBE5F1;mso-pattern:#DBE5F1 none">x</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:none;border-bottom:.5pt solid white;border-left: none;background:#DBE5F1;mso-pattern:#DBE5F1 none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt;font-size:11.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:Calibri;border-top:none;border-right:.5pt solid white; border-bottom:.5pt solid white;border-left:none;background:#B8CCE4; mso-pattern:#B8CCE4 none" align="right" height="20">5</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#B8CCE4;mso-pattern:#B8CCE4 none">x</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#B8CCE4;mso-pattern:#B8CCE4 none">
</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#B8CCE4;mso-pattern:#B8CCE4 none">
</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:none;border-bottom:.5pt solid white;border-left: none;background:#B8CCE4;mso-pattern:#B8CCE4 none">x</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt;font-size:11.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:Calibri;border-top:none;border-right:.5pt solid white; border-bottom:.5pt solid white;border-left:none;background:#DBE5F1; mso-pattern:#DBE5F1 none" align="right" height="20">6</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#DBE5F1;mso-pattern:#DBE5F1 none">
</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#DBE5F1;mso-pattern:#DBE5F1 none">
</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#DBE5F1;mso-pattern:#DBE5F1 none">
</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:none;border-bottom:.5pt solid white;border-left: none;background:#DBE5F1;mso-pattern:#DBE5F1 none">x</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt;font-size:11.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:Calibri;border-top:none;border-right:.5pt solid white; border-bottom:none;border-left:none;background:#B8CCE4;mso-pattern:#B8CCE4 none" align="right" height="20">7</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:none;border-left: none;background:#B8CCE4;mso-pattern:#B8CCE4 none">
</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:none;border-left: none;background:#B8CCE4;mso-pattern:#B8CCE4 none">
</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:none;border-left: none;background:#B8CCE4;mso-pattern:#B8CCE4 none">
</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; background:#B8CCE4;mso-pattern:#B8CCE4 none">x</td> </tr> </tbody></table>

B
<table border="0" cellpadding="0" cellspacing="0" width="532"><colgroup><col style="mso-width-source:userset;mso-width-alt:2779; width:57pt" span="7" width="76"> </colgroup><tbody><tr style="height:15.0pt" height="20"> <td style="height:15.0pt;width:57pt;font-size:11.0pt; color:white;font-weight:700;text-decoration:none;text-underline-style:none; text-line-through:none;font-family:Calibri;border-top:none;border-right:.5pt solid white; border-bottom:1.5pt solid white;border-left:none;background:#4F81BD; mso-pattern:#4F81BD none" height="20" width="76">Column1</td> <td style="width:57pt;font-size:11.0pt;color:white;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:none;border-right:.5pt solid white;border-bottom: 1.5pt solid white;border-left:none;background:#4F81BD;mso-pattern:#4F81BD none" width="76">Column2</td> <td style="width:57pt;font-size:11.0pt;color:white;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:none;border-right:.5pt solid white;border-bottom: 1.5pt solid white;border-left:none;background:#4F81BD;mso-pattern:#4F81BD none" width="76">Column3</td> <td style="width:57pt;font-size:11.0pt;color:white;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:none;border-right:.5pt solid white;border-bottom: 1.5pt solid white;border-left:none;background:#4F81BD;mso-pattern:#4F81BD none" width="76">Column4</td> <td style="width:57pt;font-size:11.0pt;color:white;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:none;border-right:.5pt solid white;border-bottom: 1.5pt solid white;border-left:none;background:#4F81BD;mso-pattern:#4F81BD none" width="76">Column5</td> <td style="width:57pt;font-size:11.0pt;color:white;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:none;border-right:.5pt solid white;border-bottom: 1.5pt solid white;border-left:none;background:#4F81BD;mso-pattern:#4F81BD none" width="76">Column6</td> <td style="width:57pt;font-size:11.0pt;color:white;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:none;border-right:none;border-bottom:1.5pt solid white; border-left:none;background:#4F81BD;mso-pattern:#4F81BD none" width="76">Column7</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt;font-size:11.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:Calibri;border-top:none;border-right:.5pt solid white; border-bottom:.5pt solid white;border-left:none;background:#B8CCE4; mso-pattern:#B8CCE4 none" align="right" height="20">1</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#B8CCE4;mso-pattern:#B8CCE4 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#B8CCE4;mso-pattern:#B8CCE4 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#B8CCE4;mso-pattern:#B8CCE4 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#B8CCE4;mso-pattern:#B8CCE4 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#B8CCE4;mso-pattern:#B8CCE4 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:none;border-bottom:.5pt solid white;border-left: none;background:#B8CCE4;mso-pattern:#B8CCE4 none">(text)</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt;font-size:11.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:Calibri;border-top:none;border-right:.5pt solid white; border-bottom:.5pt solid white;border-left:none;background:#DBE5F1; mso-pattern:#DBE5F1 none" align="right" height="20">2</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#DBE5F1;mso-pattern:#DBE5F1 none">
</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#DBE5F1;mso-pattern:#DBE5F1 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#DBE5F1;mso-pattern:#DBE5F1 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#DBE5F1;mso-pattern:#DBE5F1 none">
</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#DBE5F1;mso-pattern:#DBE5F1 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:none;border-bottom:.5pt solid white;border-left: none;background:#DBE5F1;mso-pattern:#DBE5F1 none">(text)</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt;font-size:11.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:Calibri;border-top:none;border-right:.5pt solid white; border-bottom:.5pt solid white;border-left:none;background:#B8CCE4; mso-pattern:#B8CCE4 none" align="right" height="20">3</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#B8CCE4;mso-pattern:#B8CCE4 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#B8CCE4;mso-pattern:#B8CCE4 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#B8CCE4;mso-pattern:#B8CCE4 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#B8CCE4;mso-pattern:#B8CCE4 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#B8CCE4;mso-pattern:#B8CCE4 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:none;border-bottom:.5pt solid white;border-left: none;background:#B8CCE4;mso-pattern:#B8CCE4 none">(text)</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt;font-size:11.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:Calibri;border-top:none;border-right:.5pt solid white; border-bottom:.5pt solid white;border-left:none;background:#DBE5F1; mso-pattern:#DBE5F1 none" align="right" height="20">4</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#DBE5F1;mso-pattern:#DBE5F1 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#DBE5F1;mso-pattern:#DBE5F1 none">
</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#DBE5F1;mso-pattern:#DBE5F1 none">
</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#DBE5F1;mso-pattern:#DBE5F1 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#DBE5F1;mso-pattern:#DBE5F1 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:none;border-bottom:.5pt solid white;border-left: none;background:#DBE5F1;mso-pattern:#DBE5F1 none">(text)</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt;font-size:11.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:Calibri;border-top:none;border-right:.5pt solid white; border-bottom:.5pt solid white;border-left:none;background:#B8CCE4; mso-pattern:#B8CCE4 none" align="right" height="20">5</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#B8CCE4;mso-pattern:#B8CCE4 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#B8CCE4;mso-pattern:#B8CCE4 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#B8CCE4;mso-pattern:#B8CCE4 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#B8CCE4;mso-pattern:#B8CCE4 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#B8CCE4;mso-pattern:#B8CCE4 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:none;border-bottom:.5pt solid white;border-left: none;background:#B8CCE4;mso-pattern:#B8CCE4 none">(text)</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt;font-size:11.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:Calibri;border-top:none;border-right:.5pt solid white; border-bottom:.5pt solid white;border-left:none;background:#DBE5F1; mso-pattern:#DBE5F1 none" align="right" height="20">6</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#DBE5F1;mso-pattern:#DBE5F1 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#DBE5F1;mso-pattern:#DBE5F1 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#DBE5F1;mso-pattern:#DBE5F1 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#DBE5F1;mso-pattern:#DBE5F1 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#DBE5F1;mso-pattern:#DBE5F1 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:none;border-bottom:.5pt solid white;border-left: none;background:#DBE5F1;mso-pattern:#DBE5F1 none">(text)</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt;font-size:11.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:Calibri;border-top:none;border-right:.5pt solid white; border-bottom:none;border-left:none;background:#B8CCE4;mso-pattern:#B8CCE4 none" align="right" height="20">7</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:none;border-left: none;background:#B8CCE4;mso-pattern:#B8CCE4 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:none;border-left: none;background:#B8CCE4;mso-pattern:#B8CCE4 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:none;border-left: none;background:#B8CCE4;mso-pattern:#B8CCE4 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:none;border-left: none;background:#B8CCE4;mso-pattern:#B8CCE4 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:none;border-left: none;background:#B8CCE4;mso-pattern:#B8CCE4 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; background:#B8CCE4;mso-pattern:#B8CCE4 none">(text)</td> </tr> </tbody></table>




A
<table border="0" cellpadding="0" cellspacing="0" width="380"><colgroup><col style="mso-width-source:userset;mso-width-alt:2779; width:57pt" span="5" width="76"> </colgroup><tbody><tr style="height:15.0pt" height="20"> <td style="height:15.0pt;width:57pt;font-size:11.0pt; color:white;font-weight:700;text-decoration:none;text-underline-style:none; text-line-through:none;font-family:Calibri;border-top:none;border-right:.5pt solid white; border-bottom:1.5pt solid white;border-left:none;background:#4F81BD; mso-pattern:#4F81BD none" height="20" width="76">Column1</td> <td style="width:57pt;font-size:11.0pt;color:white;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:none;border-right:.5pt solid white;border-bottom: 1.5pt solid white;border-left:none;background:#4F81BD;mso-pattern:#4F81BD none" width="76">Column2</td> <td style="width:57pt;font-size:11.0pt;color:white;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:none;border-right:.5pt solid white;border-bottom: 1.5pt solid white;border-left:none;background:#4F81BD;mso-pattern:#4F81BD none" width="76">Column3</td> <td style="width:57pt;font-size:11.0pt;color:white;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:none;border-right:.5pt solid white;border-bottom: 1.5pt solid white;border-left:none;background:#4F81BD;mso-pattern:#4F81BD none" width="76">Column4</td> <td style="width:57pt;font-size:11.0pt;color:white;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:none;border-right:none;border-bottom:1.5pt solid white; border-left:none;background:#4F81BD;mso-pattern:#4F81BD none" width="76">Column5</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt;font-size:11.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:Calibri;border-top:none;border-right:.5pt solid white; border-bottom:.5pt solid white;border-left:none;background:#B8CCE4; mso-pattern:#B8CCE4 none" align="right" height="20">1</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#B8CCE4;mso-pattern:#B8CCE4 none">x</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#B8CCE4;mso-pattern:#B8CCE4 none">
</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#B8CCE4;mso-pattern:#B8CCE4 none">
</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:none;border-bottom:.5pt solid white;border-left: none;background:#B8CCE4;mso-pattern:#B8CCE4 none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt;font-size:11.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:Calibri;border-top:none;border-right:.5pt solid white; border-bottom:.5pt solid white;border-left:none;background:#DBE5F1; mso-pattern:#DBE5F1 none" align="right" height="20">2</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#DBE5F1;mso-pattern:#DBE5F1 none">
</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#DBE5F1;mso-pattern:#DBE5F1 none">x</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#DBE5F1;mso-pattern:#DBE5F1 none">x</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:none;border-bottom:.5pt solid white;border-left: none;background:#DBE5F1;mso-pattern:#DBE5F1 none">x</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt;font-size:11.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:Calibri;border-top:none;border-right:.5pt solid white; border-bottom:.5pt solid white;border-left:none;background:#B8CCE4; mso-pattern:#B8CCE4 none" align="right" height="20">4</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#B8CCE4;mso-pattern:#B8CCE4 none">x</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#B8CCE4;mso-pattern:#B8CCE4 none">x</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#B8CCE4;mso-pattern:#B8CCE4 none">x</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:none;border-bottom:.5pt solid white;border-left: none;background:#B8CCE4;mso-pattern:#B8CCE4 none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt;font-size:11.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:Calibri;border-top:none;border-right:.5pt solid white; border-bottom:.5pt solid white;border-left:none;background:#DBE5F1; mso-pattern:#DBE5F1 none" align="right" height="20">5</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#DBE5F1;mso-pattern:#DBE5F1 none">x</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#DBE5F1;mso-pattern:#DBE5F1 none">
</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#DBE5F1;mso-pattern:#DBE5F1 none">
</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:none;border-bottom:.5pt solid white;border-left: none;background:#DBE5F1;mso-pattern:#DBE5F1 none">x</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt;font-size:11.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:Calibri;border-top:none;border-right:.5pt solid white; border-bottom:.5pt solid white;border-left:none;background:#B8CCE4; mso-pattern:#B8CCE4 none" align="right" height="20">6</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#B8CCE4;mso-pattern:#B8CCE4 none">
</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#B8CCE4;mso-pattern:#B8CCE4 none">
</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#B8CCE4;mso-pattern:#B8CCE4 none">
</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:none;border-bottom:.5pt solid white;border-left: none;background:#B8CCE4;mso-pattern:#B8CCE4 none">x</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt;font-size:11.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:Calibri;border-top:none;border-right:.5pt solid white; border-bottom:none;border-left:none;background:#DBE5F1;mso-pattern:#DBE5F1 none" align="right" height="20">7</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:none;border-left: none;background:#DBE5F1;mso-pattern:#DBE5F1 none">
</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:none;border-left: none;background:#DBE5F1;mso-pattern:#DBE5F1 none">
</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:none;border-left: none;background:#DBE5F1;mso-pattern:#DBE5F1 none">
</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; background:#DBE5F1;mso-pattern:#DBE5F1 none">x</td> </tr> </tbody></table>
B
<table border="0" cellpadding="0" cellspacing="0" width="532"><colgroup><col style="mso-width-source:userset;mso-width-alt:2779; width:57pt" span="7" width="76"> </colgroup><tbody><tr style="height:15.0pt" height="20"> <td style="height:15.0pt;width:57pt;font-size:11.0pt; color:white;font-weight:700;text-decoration:none;text-underline-style:none; text-line-through:none;font-family:Calibri;border-top:none;border-right:.5pt solid white; border-bottom:1.5pt solid white;border-left:none;background:#4F81BD; mso-pattern:#4F81BD none" height="20" width="76">Column1</td> <td style="width:57pt;font-size:11.0pt;color:white;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:none;border-right:.5pt solid white;border-bottom: 1.5pt solid white;border-left:none;background:#4F81BD;mso-pattern:#4F81BD none" width="76">Column2</td> <td style="width:57pt;font-size:11.0pt;color:white;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:none;border-right:.5pt solid white;border-bottom: 1.5pt solid white;border-left:none;background:#4F81BD;mso-pattern:#4F81BD none" width="76">Column3</td> <td style="width:57pt;font-size:11.0pt;color:white;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:none;border-right:.5pt solid white;border-bottom: 1.5pt solid white;border-left:none;background:#4F81BD;mso-pattern:#4F81BD none" width="76">Column4</td> <td style="width:57pt;font-size:11.0pt;color:white;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:none;border-right:.5pt solid white;border-bottom: 1.5pt solid white;border-left:none;background:#4F81BD;mso-pattern:#4F81BD none" width="76">Column5</td> <td style="width:57pt;font-size:11.0pt;color:white;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:none;border-right:.5pt solid white;border-bottom: 1.5pt solid white;border-left:none;background:#4F81BD;mso-pattern:#4F81BD none" width="76">Column6</td> <td style="width:57pt;font-size:11.0pt;color:white;font-weight:700; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:Calibri;border-top:none;border-right:none;border-bottom:1.5pt solid white; border-left:none;background:#4F81BD;mso-pattern:#4F81BD none" width="76">Column7</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt;font-size:11.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:Calibri;border-top:none;border-right:.5pt solid white; border-bottom:.5pt solid white;border-left:none;background:#B8CCE4; mso-pattern:#B8CCE4 none" align="right" height="20">1</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#B8CCE4;mso-pattern:#B8CCE4 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#B8CCE4;mso-pattern:#B8CCE4 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#B8CCE4;mso-pattern:#B8CCE4 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#B8CCE4;mso-pattern:#B8CCE4 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#B8CCE4;mso-pattern:#B8CCE4 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:none;border-bottom:.5pt solid white;border-left: none;background:#B8CCE4;mso-pattern:#B8CCE4 none">(text)</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt;font-size:11.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:Calibri;border-top:none;border-right:.5pt solid white; border-bottom:.5pt solid white;border-left:none;background:#DBE5F1; mso-pattern:#DBE5F1 none" align="right" height="20">2</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#DBE5F1;mso-pattern:#DBE5F1 none">
</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#DBE5F1;mso-pattern:#DBE5F1 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#DBE5F1;mso-pattern:#DBE5F1 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#DBE5F1;mso-pattern:#DBE5F1 none">
</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#DBE5F1;mso-pattern:#DBE5F1 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:none;border-bottom:.5pt solid white;border-left: none;background:#DBE5F1;mso-pattern:#DBE5F1 none">(text)</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt;font-size:11.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:Calibri;border-top:none;border-right:.5pt solid white; border-bottom:.5pt solid white;border-left:none;background:#B8CCE4; mso-pattern:#B8CCE4 none" align="right" height="20">4</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#B8CCE4;mso-pattern:#B8CCE4 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#B8CCE4;mso-pattern:#B8CCE4 none">
</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#B8CCE4;mso-pattern:#B8CCE4 none">
</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#B8CCE4;mso-pattern:#B8CCE4 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#B8CCE4;mso-pattern:#B8CCE4 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:none;border-bottom:.5pt solid white;border-left: none;background:#B8CCE4;mso-pattern:#B8CCE4 none">(text)</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt;font-size:11.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:Calibri;border-top:none;border-right:.5pt solid white; border-bottom:.5pt solid white;border-left:none;background:#DBE5F1; mso-pattern:#DBE5F1 none" align="right" height="20">5</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#DBE5F1;mso-pattern:#DBE5F1 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#DBE5F1;mso-pattern:#DBE5F1 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#DBE5F1;mso-pattern:#DBE5F1 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#DBE5F1;mso-pattern:#DBE5F1 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#DBE5F1;mso-pattern:#DBE5F1 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:none;border-bottom:.5pt solid white;border-left: none;background:#DBE5F1;mso-pattern:#DBE5F1 none">(text)</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt;font-size:11.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:Calibri;border-top:none;border-right:.5pt solid white; border-bottom:.5pt solid white;border-left:none;background:#B8CCE4; mso-pattern:#B8CCE4 none" align="right" height="20">6</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#B8CCE4;mso-pattern:#B8CCE4 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#B8CCE4;mso-pattern:#B8CCE4 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#B8CCE4;mso-pattern:#B8CCE4 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#B8CCE4;mso-pattern:#B8CCE4 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:.5pt solid white; border-left:none;background:#B8CCE4;mso-pattern:#B8CCE4 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:none;border-bottom:.5pt solid white;border-left: none;background:#B8CCE4;mso-pattern:#B8CCE4 none">(text)</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt;font-size:11.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:Calibri;border-top:none;border-right:.5pt solid white; border-bottom:none;border-left:none;background:#DBE5F1;mso-pattern:#DBE5F1 none" align="right" height="20">7</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:none;border-left: none;background:#DBE5F1;mso-pattern:#DBE5F1 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:none;border-left: none;background:#DBE5F1;mso-pattern:#DBE5F1 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:none;border-left: none;background:#DBE5F1;mso-pattern:#DBE5F1 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:none;border-left: none;background:#DBE5F1;mso-pattern:#DBE5F1 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; border-top:none;border-right:.5pt solid white;border-bottom:none;border-left: none;background:#DBE5F1;mso-pattern:#DBE5F1 none">(text)</td> <td style="font-size:11.0pt;color:black;font-weight:400;text-decoration:none; text-underline-style:none;text-line-through:none;font-family:Calibri; background:#DBE5F1;mso-pattern:#DBE5F1 none">(text)</td> </tr> </tbody></table>




I've currently got Table A's header column as
=IFERROR('Table B'!A$2:A$99," ")
and this keeps the columns equal, but not the rest of the table (i.e. adding/deleting rows). If I remove a row from B, I need the associated row in A to be removed as well, the same for adding a row. The way I have the workbook set now, data can only be added/removed from B so it the method does not have to work in reverse.
Really appreciate any help
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

Forum statistics

Threads
1,224,616
Messages
6,179,908
Members
452,949
Latest member
beartooth91

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