I have a spreadsheet that appears as follows on my Sheet1 worksheet:
******** ******************** ************************************************************************><center><table align="center" cellpadding="0" cellspacing="0"><tbody><tr><td style="border-left: 0.5pt solid rgb(0, 0, 0); border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0);" colspan="7" bgcolor="#0c266b"><table width="100%" align="center" border="0"><tbody><tr><td align="left">
Microsoft Excel - Book1</td><td style="font-family: caption; color: rgb(255, 255, 255); font-size: 9pt;" align="right">___Running: 14.0 : OS = </td></tr></tbody></table></td></tr><tr><td style="border-left: 0.5pt solid rgb(0, 0, 0); height: 25px; border-right: 0.5pt solid rgb(0, 0, 0);" colspan="7" bgcolor="#d4d0c8"><table valign="MIDDLE" width="100%" align="center" border="0"><tbody><tr><td style="font-family: caption; color: rgb(0, 0, 0); font-size: 10pt;">(
F)ile (
E)dit (
V)iew (
I)nsert (
O)ptions (
T)ools (
D)ata (
W)indow (
H)elp
(A)bout</td><td valign="middle" align="right"><form name="formCb605117"><input *******="window.clipboardData.setData("Text",document.formFb202339.sltNb447362.value);" name="btCb942116" value="Copy Formula" type="button"></form></td></tr></tbody></table></td></tr><tr><td style="border-left: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0);" colspan="7" bgcolor="white"><table border="0"><tbody><tr><form name="formFb202339"></form><td style="width: 60px;" align="center" bgcolor="white"><select onchange="document.formFb202339.txbFb150492.value = document.formFb202339.sltNb447362.value" name="sltNb447362"><option selected="selected" value="CCNA">A1</option></select></td><td width="3%" align="right" bgcolor="#d4d0c8">
=</td><td align="left" bgcolor="white"><input name="txbFb150492" value="Full Name" size="80"></td></tr></tbody></table></td></tr><tr><td style="border-left: 0.5pt solid rgb(0, 0, 0); background-color: rgb(212, 208, 200); border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0);" width="2%" align="center">
</td><td style="background-color: rgb(212, 208, 200); font-family: menu; color: black; font-size: 10pt; border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0);" align="center"><center>A</center></td><td style="background-color: rgb(212, 208, 200); font-family: menu; color: black; font-size: 10pt; border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0);" align="center"><center>B</center></td><td style="background-color: rgb(212, 208, 200); font-family: menu; color: black; font-size: 10pt; border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0);" align="center"><center>C</center></td><td style="background-color: rgb(212, 208, 200); font-family: menu; color: black; font-size: 10pt; border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0);" align="center"><center>D</center></td><td style="background-color: rgb(212, 208, 200); font-family: menu; color: black; font-size: 10pt; border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0);" align="center"><center>E</center></td><td style="background-color: rgb(212, 208, 200); font-family: menu; color: black; font-size: 10pt; border-top: 0.5pt solid rgb(0, 0, 0); border-right: 0.5pt solid rgb(0, 0, 0);" align="center"><center>F</center></td></tr><tr><td style="border-left: 0.5pt solid rgb(0, 0, 0); background-color: rgb(212, 208, 200); font-family: menu; color: rgb(0, 0, 0); font-size: 10pt; border-top: 0.5pt solid rgb(0, 0, 0);" width="2%" align="center"><center>1</center></td><td style="border: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(0, 204, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; font-weight: bold;">Full Name</td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 0); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-top: 0.5pt solid rgb(0, 0, 0); font-weight: bold; border-right: 0.5pt solid rgb(0, 0, 0);">Associate SE</td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 0); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-top: 0.5pt solid rgb(0, 0, 0); font-weight: bold; border-right: 0.5pt solid rgb(0, 0, 0);">Completed via SE Program or Prior Experience?</td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 0); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-top: 0.5pt solid rgb(0, 0, 0); font-weight: bold; border-right: 0.5pt solid rgb(0, 0, 0);">
Server+ or Equivalent</td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 0); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-top: 0.5pt solid rgb(0, 0, 0); font-weight: bold; border-right: 0.5pt solid rgb(0, 0, 0);">
Linux+ or Equivalent</td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 0); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-top: 0.5pt solid rgb(0, 0, 0); font-weight: bold; border-right: 0.5pt solid rgb(0, 0, 0);">
Network+ or Equivalent</td></tr><tr><td style="border-left: 0.5pt solid rgb(0, 0, 0); background-color: rgb(212, 208, 200); font-family: menu; color: rgb(0, 0, 0); font-size: 10pt; border-top: 0.5pt solid rgb(0, 0, 0);" width="2%" align="center"><center>2</center></td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; border-left: 0.5pt solid rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);">Allen, Keith</td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);">No Certifications</td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);"> </td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);"> </td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);"> </td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);"> </td></tr><tr><td style="border-left: 0.5pt solid rgb(0, 0, 0); background-color: rgb(212, 208, 200); font-family: menu; color: rgb(0, 0, 0); font-size: 10pt; border-top: 0.5pt solid rgb(0, 0, 0);" width="2%" align="center"><center>3</center></td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; border-left: 0.5pt solid rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);">Amill, Julio</td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);">Partial (1 Certification)</td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);">SE Training Program</td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);">Server+</td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);"> </td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);"> </td></tr><tr><td style="border-left: 0.5pt solid rgb(0, 0, 0); background-color: rgb(212, 208, 200); font-family: menu; color: rgb(0, 0, 0); font-size: 10pt; border-top: 0.5pt solid rgb(0, 0, 0);" width="2%" align="center"><center>4</center></td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; border-left: 0.5pt solid rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);">Ang, Swee Hong</td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);">Partial (1 Certification)</td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);"> </td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);">Server+</td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);"> </td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);"> </td></tr><tr><td style="border-left: 0.5pt solid rgb(0, 0, 0); background-color: rgb(212, 208, 200); font-family: menu; color: rgb(0, 0, 0); font-size: 10pt; border-top: 0.5pt solid rgb(0, 0, 0);" width="2%" align="center"><center>5</center></td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; border-left: 0.5pt solid rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);">Balcerzak, Antony</td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);">Yes (2 Certifications)</td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);">Prior Experience & Certifications</td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);">Server+, CIW Associate</td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);"> </td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);">CCNA</td></tr><tr><td style="border-left: 0.5pt solid rgb(0, 0, 0); background-color: rgb(212, 208, 200); font-family: menu; color: rgb(0, 0, 0); font-size: 10pt; border-top: 0.5pt solid rgb(0, 0, 0);" width="2%" align="center"><center>6</center></td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; border-left: 0.5pt solid rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: bottom; border-right: 0.5pt solid rgb(0, 0, 0);">Balharek, Oldrich</td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);">Partial (1 Certification)</td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);"> </td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);"> </td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);"> </td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);">Network+</td></tr><tr><td style="border-left: 0.5pt solid rgb(0, 0, 0); background-color: rgb(212, 208, 200); font-family: menu; color: rgb(0, 0, 0); font-size: 10pt; border-top: 0.5pt solid rgb(0, 0, 0);" width="2%" align="center"><center>7</center></td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; border-left: 0.5pt solid rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);">Basinski, Grzegorz</td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);">Yes (2 Certifications)</td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);">Prior Experience & Certifications</td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);">Server+</td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);"> </td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);">CCNA</td></tr><tr><td style="border-left: 0.5pt solid rgb(0, 0, 0); background-color: rgb(212, 208, 200); font-family: menu; color: rgb(0, 0, 0); font-size: 10pt; border-top: 0.5pt solid rgb(0, 0, 0);" width="2%" align="center"><center>8</center></td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; border-left: 0.5pt solid rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);">Beard, Joseph</td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);">Yes (2 Certifications)</td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);">Prior Experience & Certifications</td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);">MCSE</td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);"> </td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);">CCNA</td></tr><tr><td style="border-left: 0.5pt solid rgb(0, 0, 0); background-color: rgb(212, 208, 200); font-family: menu; color: rgb(0, 0, 0); font-size: 10pt; border-top: 0.5pt solid rgb(0, 0, 0);" width="2%" align="center"><center>9</center></td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; border-left: 0.5pt solid rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);">Bechman, Oliver</td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);">Yes (2 Certifications)</td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);">Prior Experience & Certifications</td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);">Server+</td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);"> </td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);">CCNA</td></tr><tr><td style="border-left: 0.5pt solid rgb(0, 0, 0); background-color: rgb(212, 208, 200); font-family: menu; color: rgb(0, 0, 0); font-size: 10pt; border-top: 0.5pt solid rgb(0, 0, 0);" width="2%" align="center"><center>10</center></td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; border-left: 0.5pt solid rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);">Bentley, Clinton</td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);">Partial (1 Certification)</td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);">Prior Experience & Certifications</td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);"> </td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);"> </td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);">CCNP</td></tr><tr><td style="border-left: 0.5pt solid rgb(0, 0, 0); background-color: rgb(212, 208, 200); font-family: menu; color: rgb(0, 0, 0); font-size: 10pt; border-top: 0.5pt solid rgb(0, 0, 0);" width="2%" align="center"><center>11</center></td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; border-left: 0.5pt solid rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);">Bermundo, Dexter</td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);">Partial (1 Certification)</td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);">Prior Experience & Certifications</td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);"> </td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);"> </td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);">CCNA</td></tr><tr><td style="border-left: 0.5pt solid rgb(0, 0, 0); background-color: rgb(212, 208, 200); font-family: menu; color: rgb(0, 0, 0); font-size: 10pt; border-top: 0.5pt solid rgb(0, 0, 0);" width="2%" align="center"><center>12</center></td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; border-left: 0.5pt solid rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);">Bernini, Andrea</td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);">Yes (2 Certifications)</td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);"> </td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);">Server+</td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);">Linux+</td><td style="border-bottom: 0.5pt solid rgb(0, 0, 0); text-align: center; background-color: rgb(255, 255, 255); font-family: Calibri; color: rgb(0, 0, 0); font-size: 11pt; vertical-align: middle; border-right: 0.5pt solid rgb(0, 0, 0);">CCNA</td></tr><tr><td style="border-width: 0.5pt; border-style: solid; border-color: rgb(128, 128, 128) rgb(0, 0, 0) rgb(0, 0, 0); background-color: rgb(212, 208, 200);" colspan="7"><table valign="TOP" width="100%" align="left"><tbody><tr><td style="border-width: 0.5pt; border-style: solid; border-color: rgb(128, 128, 128) rgb(0, 0, 0) rgb(0, 0, 0); background-color: rgb(255, 255, 255); width: 120pt;" align="left">
Sheet1</td><td> </td></tr></tbody></table></td></tr></tbody></table>
[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.</center>
What I need on Sheet2 of my workbook is to have 2 drop down cells where the 1st cell (A2) would be a drop down List of all the names in column A of Sheet1 and the 2nd cell (B2) would be the corresponding values in the row (columns B:F) of that name.
So for example, if I select the name Amil, Julio from the drop down List of cell A2 then the drop down List of cell B2 would update with the corresponding values (Partial 1 (Certification), SE Trainging Program, Server+) of that name.
Can anyone advise?
