Grouping HELP!

[rainx]

I have a feeling my previous thread wasnt well understood, so I guess mayb I should show a sample data. Well my sample is as follow, basically, what I needa do is to group these entries into their respective groups, eg, apple, orange and pear. However, my issue is my Groups will vary each time I run a report. Is there any way I can group these entries based on their groups into individual files, or if not possible, sheets, named under their group name. Hope someone is able to help. THANKS ALOT!

<table x:str="" style="border-collapse: collapse; width: 330pt;" width="440" border="0" cellpadding="0" cellspacing="0"><col style="width: 126pt;" width="168"> <col style="width: 156pt;" width="208"> <col style="width: 48pt;" width="64"> <tbody><tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt; width: 126pt;" width="168" height="17">Column A</td> <td style="width: 156pt;" width="208">Column B</td> <td style="width: 48pt;" width="64">Column C</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" height="17">Apple</td> <td class="xl24" style="border-left: medium none;">asdf</td> <td class="xl24" style="border-left: medium none;" x:num="" align="right">12</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" height="17">Apple</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">asdfsaf</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">312312</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" height="17">Apple</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">asfdsdf</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">313123</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" height="17">Apple</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">asdfasdf</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">3123113</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" height="17">Apple</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">sadfsaf</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">123</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" height="17">Apple</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">asdfsaf</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">1213</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" height="17">Apple</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">fasfs</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">123</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" height="17">Apple</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">fasff</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">3</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" height="17">Orange</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">asdfasdf</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">12</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" height="17">Orange</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">fsf</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">123</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" height="17">Orange</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">safsfaf</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">123</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" height="17">Orange</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">safsdfs</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">3</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" height="17">Orange</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">afsafa</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">123</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" height="17">Orange</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">sdfasfa</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">13</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" height="17">Pear</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">fsfasfsf</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">12</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" height="17">Pear</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">asfdsfas</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">3</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" height="17">Pear</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">asdfsf</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" height="17">Pear</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">adfsf</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">212</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" height="17">Pear</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">asdfsaf</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">3</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" height="17">Pear</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">asfsf</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">123</td> </tr> </tbody></table>

 

[cornflakegirl]

Duplicate resolved here http://www.mrexcel.com/forum/showthread.php?t=328795