jpenndcl ,
Screenshots of your worksheets would help.
Please post a screenshot of your sheet(s), what you have and what you expect to achieve, with Excel Jeanie HTML 4.
http://www.excel-jeanie-html.de/index.php?f=1
Instructions for using "Excel Jeanie HTML 4":
http://www.excel-jeanie-html.de/html/hlp_schnell_en.php
Have a great day,
Stan
The program wouldn't let me download it, but perhaps I can put some more illustrative examples in here
(Data tab)
<table x:str="" style="border-collapse: collapse;" width="466" border="0" cellpadding="0" cellspacing="0" height="67"><col style="width: 48pt;" span="4" width="64"> <col style="width: 58pt;" width="77"> <col style="width: 48pt;" span="2" width="64"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt; width: 48pt;" x:num="37257" width="64" align="right" height="17">1/1/2002</td> <td class="xl23" style="width: 48pt;" x:num="0.41666666666666669" width="64" align="right"> 10:00
</td> <td style="width: 48pt;" width="64"> bob</td> <td valign="top">
</td><td valign="top">
</td><td style="width: 48pt;" x:num="" width="64" align="right">123
</td> <td style="width: 58pt;" width="77"> s</td> <td style="width: 48pt;" x:num="" width="64" align="right">1</td> <td style="width: 48pt;" width="64">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt;" x:num="39451" align="right" height="17">1/4/2008</td> <td class="xl23" x:num="0.5" align="right">12:00
</td> <td> anne</td> <td valign="top">
</td><td valign="top">
</td><td x:num="" align="right">214</td> <td> s</td> <td x:num="" align="right">3</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt;" x:num="38780" align="right" height="17">3/4/2006</td> <td class="xl23" x:num="0.25" align="right">6:00
</td> <td> jeff</td> <td valign="top">
</td><td valign="top">
</td><td x:num="" align="right">231</td> <td> s</td> <td x:num="" align="right">3</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt;" x:num="37843" align="right" height="17">8/10/2003</td> <td class="xl23" x:num="0.64583333333333337" align="right">3:30
</td> <td> dale</td> <td valign="top">
</td><td valign="top">
</td><td x:num="" align="right">421</td> <td> s</td> <td x:num="" align="right">2</td> <td>
</td> </tr> </tbody></table>
(Data to be inserted in library tab)
<table x:str="" style="border-collapse: collapse; width: 240pt;" width="320" border="0" cellpadding="0" cellspacing="0"><col style="width: 48pt;" span="5" width="64"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; width: 48pt;" x:num="37257" width="64" align="right" height="17">1/1/2002</td> <td class="xl24" style="width: 48pt;" width="64"> home</td> <td class="xl25" style="width: 48pt;" x:num="0.41666666666666669" width="64" align="right">10:00
</td> <td style="width: 48pt;" width="64"> bob</td> <td style="width: 48pt;" x:num="" width="64" align="right">123</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" x:num="39451" align="right" height="17">1/4/2008</td> <td class="xl24" x:str="lunch "> lunch </td> <td class="xl25" x:num="0.5" align="right">12:00
</td> <td> anne</td> <td x:num="" align="right">214</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" x:num="38780" align="right" height="17">3/4/2006</td> <td class="xl24" x:str="lunch "> lunch </td> <td class="xl25" x:num="0.25" align="right">6:00
</td> <td> jeff</td> <td x:num="" align="right">231</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" x:num="37843" align="right" height="17">8/10/2003</td> <td class="xl24"> variable</td> <td class="xl25" x:num="0.64583333333333337" align="right">3:30
</td> <td> dale</td> <td x:num="" align="right">421</td> </tr> </tbody></table>
(categories tab)
<table x:str="" style="border-collapse: collapse; width: 48pt;" width="64" border="0" cellpadding="0" cellspacing="0"><col style="width: 48pt;" width="64"> <tbody><tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt; width: 48pt;" width="64" height="17">home</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:str="variable " height="17">variable </td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">lunch</td> </tr> </tbody></table>
(library tab... not part of the macro, but the end result after I insert the categorized data from the "data to be inserted into library" tab at the end of the already existing library)
<table x:str="" style="border-collapse: collapse; width: 240pt;" width="320" border="0" cellpadding="0" cellspacing="0"><col style="width: 48pt;" span="5" width="64"> <tbody><tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt; width: 48pt;" width="64" height="17">Date</td> <td style="width: 48pt;" width="64">Category</td> <td style="width: 48pt;" width="64">Time</td> <td style="width: 48pt;" width="64">Name</td> <td style="width: 48pt;" width="64">Number</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" x:num="37257" align="right" height="17">1/1/2002</td> <td class="xl24"> home</td> <td class="xl25" x:num="0.41666666666666669" align="right">10:00
</td> <td> bob</td> <td x:num="" align="right">123</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" x:num="39451" align="right" height="17">1/4/2008
</td> <td class="xl24" x:str="lunch "> lunch </td> <td class="xl25" x:num="0.5" align="right">12:00
</td> <td> anne</td> <td x:num="" align="right">214</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" x:num="38780" align="right" height="17">3/4/2006</td> <td class="xl24" x:str="lunch "> lunch </td> <td class="xl25" x:num="0.25" align="right">6:00
</td> <td> jeff</td> <td x:num="" align="right">231</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" x:num="37843" align="right" height="17">8/10/2003</td> <td class="xl24"> variable</td> <td class="xl25" x:num="0.64583333333333337" align="right">3:30
</td> <td> dale</td> <td x:num="" align="right">421</td> </tr> </tbody></table>