Good Morning;
I have a major problem and I desparetly need some help. Here is what is going on. I have a formula that I have been using to give me sequential check code and here is the formula:
<table border="1" bordercolor="#C0C0C0" bordercolordark="#FFFFFF" cellspacing="0" cellpadding="2">
<tr>
<td bgcolor="#CCFFCC" align="left" valign="bottom"><font face="Tahoma" size="2"><nobr>CHECK1</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" align="left" valign="bottom"><font face="Tahoma" size="2"><nobr>3801A</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>00002AAAAAAAAAAAAAAAAAAAAAA3801A</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" align="left" valign="bottom"><font face="Tahoma" size="2"><nobr>3802A</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>00003AAAAAAAAAAAAAAAAAAAAAA3802A</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" align="left" valign="bottom"><font face="Tahoma" size="2"><nobr>3803A</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>00004AAAAAAAAAAAAAAAAAAAAAA3803A</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" align="left" valign="bottom"><font face="Tahoma" size="2"><nobr>3804A</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>00005AAAAAAAAAAAAAAAAAAAAAA3804A</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" align="left" valign="bottom"><font face="Tahoma" size="2"><nobr>3805A</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>00006AAAAAAAAAAAAAAAAAAAAAA3805A</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
</tr>
</table>
I have been using this for ever and have not had any problem until recently when I try to copy the formula into another sheet the formula does not work and I get the same result as the formula even though column has changed. please see below:
<table border="1" bordercolor="#C0C0C0" bordercolordark="#FFFFFF" cellspacing="0" cellpadding="2">
<tr>
<td bgcolor="#CCFFCC" align="left" valign="bottom"><font face="Tahoma" size="2"><nobr>CHECK1</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" align="left" valign="bottom"><font face="Tahoma" size="2"><nobr>10393</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>00002AAAAAAAAAAAAAAAAAAAAAA3801A</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
</tr>
<tr>
<td bgcolor="#00FF00" align="left" valign="bottom"><font face="Tahoma" size="2"><nobr>10394</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>00002AAAAAAAAAAAAAAAAAAAAAA3801A</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
</tr>
<tr>
<td bgcolor="#00FF00" align="left" valign="bottom"><font face="Tahoma" size="2"><nobr>10394</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>00002AAAAAAAAAAAAAAAAAAAAAA3801A</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
</tr>
<tr>
<td bgcolor="#00FF00" align="left" valign="bottom"><font face="Tahoma" size="2"><nobr>10394</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>00002AAAAAAAAAAAAAAAAAAAAAA3801A</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
</tr>
<tr>
<td bgcolor="#00FF00" align="left" valign="bottom"><font face="Tahoma" size="2"><nobr>10394</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>00002AAAAAAAAAAAAAAAAAAAAAA3801A</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" align="left" valign="bottom"><font face="Tahoma" size="2"><nobr>10395</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>00002AAAAAAAAAAAAAAAAAAAAAA3801A</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" align="left" valign="bottom"><font face="Tahoma" size="2"><nobr>10396</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>00002AAAAAAAAAAAAAAAAAAAAAA3801A</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" align="left" valign="bottom"><font face="Tahoma" size="2"><nobr>10397</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>00002AAAAAAAAAAAAAAAAAAAAAA3801A</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
</tr>
</table>
Any idea what is going on?????
I have a major problem and I desparetly need some help. Here is what is going on. I have a formula that I have been using to give me sequential check code and here is the formula:
<table border="1" bordercolor="#C0C0C0" bordercolordark="#FFFFFF" cellspacing="0" cellpadding="2">
<tr>
<td bgcolor="#CCFFCC" align="left" valign="bottom"><font face="Tahoma" size="2"><nobr>CHECK1</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" align="left" valign="bottom"><font face="Tahoma" size="2"><nobr>3801A</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>00002AAAAAAAAAAAAAAAAAAAAAA3801A</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" align="left" valign="bottom"><font face="Tahoma" size="2"><nobr>3802A</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>00003AAAAAAAAAAAAAAAAAAAAAA3802A</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" align="left" valign="bottom"><font face="Tahoma" size="2"><nobr>3803A</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>00004AAAAAAAAAAAAAAAAAAAAAA3803A</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" align="left" valign="bottom"><font face="Tahoma" size="2"><nobr>3804A</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>00005AAAAAAAAAAAAAAAAAAAAAA3804A</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" align="left" valign="bottom"><font face="Tahoma" size="2"><nobr>3805A</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>00006AAAAAAAAAAAAAAAAAAAAAA3805A</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
</tr>
</table>
I have been using this for ever and have not had any problem until recently when I try to copy the formula into another sheet the formula does not work and I get the same result as the formula even though column has changed. please see below:
<table border="1" bordercolor="#C0C0C0" bordercolordark="#FFFFFF" cellspacing="0" cellpadding="2">
<tr>
<td bgcolor="#CCFFCC" align="left" valign="bottom"><font face="Tahoma" size="2"><nobr>CHECK1</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" align="left" valign="bottom"><font face="Tahoma" size="2"><nobr>10393</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>00002AAAAAAAAAAAAAAAAAAAAAA3801A</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
</tr>
<tr>
<td bgcolor="#00FF00" align="left" valign="bottom"><font face="Tahoma" size="2"><nobr>10394</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>00002AAAAAAAAAAAAAAAAAAAAAA3801A</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
</tr>
<tr>
<td bgcolor="#00FF00" align="left" valign="bottom"><font face="Tahoma" size="2"><nobr>10394</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>00002AAAAAAAAAAAAAAAAAAAAAA3801A</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
</tr>
<tr>
<td bgcolor="#00FF00" align="left" valign="bottom"><font face="Tahoma" size="2"><nobr>10394</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>00002AAAAAAAAAAAAAAAAAAAAAA3801A</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
</tr>
<tr>
<td bgcolor="#00FF00" align="left" valign="bottom"><font face="Tahoma" size="2"><nobr>10394</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>00002AAAAAAAAAAAAAAAAAAAAAA3801A</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" align="left" valign="bottom"><font face="Tahoma" size="2"><nobr>10395</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>00002AAAAAAAAAAAAAAAAAAAAAA3801A</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" align="left" valign="bottom"><font face="Tahoma" size="2"><nobr>10396</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>00002AAAAAAAAAAAAAAAAAAAAAA3801A</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" align="left" valign="bottom"><font face="Tahoma" size="2"><nobr>10397</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>00002AAAAAAAAAAAAAAAAAAAAAA3801A</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr></nobr></font></td>
</tr>
</table>
Any idea what is going on?????