Dundee Lad
Active Member
- Joined
- Sep 6, 2003
- Messages
- 311
i hope i have followed the instructions properly for the html maker.
I have the following table in excel, there will be many more rows. Each month the column will update to a new one. what I need is for the latest columns result to be shown in column P and always in column p. can anyone help me i am lost?
<!-- Please do not remove this header -->
<!-- Table easily created from Excel with ASAP Utilities (http://www.asap-utilities.com) -->
<table border="1" bordercolor="#C0C0C0" bordercolordark="#FFFFFF" cellspacing="0" cellpadding="2">
<tr>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>Unit</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>Department</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>Code</nobr></font></td>
<td align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>2</nobr></font></td>
<td align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>3</nobr></font></td>
<td align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>4</nobr></font></td>
<td align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>5</nobr></font></td>
<td align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>6</nobr></font></td>
<td align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>7</nobr></font></td>
<td align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>8</nobr></font></td>
<td align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>9</nobr></font></td>
<td align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>10</nobr></font></td>
<td align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>11</nobr></font></td>
<td align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>12</nobr></font></td>
</tr>
<tr>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>GFD</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>GFD321</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>GFD321BigTicket</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>42</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>
<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>
</table>
I have the following table in excel, there will be many more rows. Each month the column will update to a new one. what I need is for the latest columns result to be shown in column P and always in column p. can anyone help me i am lost?
<!-- Please do not remove this header -->
<!-- Table easily created from Excel with ASAP Utilities (http://www.asap-utilities.com) -->
<table border="1" bordercolor="#C0C0C0" bordercolordark="#FFFFFF" cellspacing="0" cellpadding="2">
<tr>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>Unit</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>Department</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>Code</nobr></font></td>
<td align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>2</nobr></font></td>
<td align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>3</nobr></font></td>
<td align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>4</nobr></font></td>
<td align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>5</nobr></font></td>
<td align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>6</nobr></font></td>
<td align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>7</nobr></font></td>
<td align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>8</nobr></font></td>
<td align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>9</nobr></font></td>
<td align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>10</nobr></font></td>
<td align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>11</nobr></font></td>
<td align="center" valign="bottom"><font face="Tahoma" size="2"><nobr>12</nobr></font></td>
</tr>
<tr>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>GFD</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>GFD321</nobr></font></td>
<td valign="bottom"><font face="Tahoma" size="2"><nobr>GFD321BigTicket</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>1</nobr></font></td>
<td align="right" valign="bottom"><font face="Tahoma" size="2"><nobr>42</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>
<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>
</table>