printing using vba

[caritx]

I have an excel file with the following data in multiple tabs. This changes daily and i print it every morning.

What I normally do is I add filters
filter by column A to show one group
Highlight the last row Bold
then print
I repeat this process for as many groups and tabs as I have.
The amount of groups and rows change everyday.

I would like a macro or vba that could automatically find the groups based on column A highlight and bold the last cell and print.

Thanks in advance for any help you can offer!

Here is a sample of the data:
<table style="border-collapse: collapse; width: 268pt;" border="0" cellpadding="0" cellspacing="0" width="357"><col style="width: 92pt;" width="123"> <col style="width: 89pt;" width="118"> <col style="width: 87pt;" width="116"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl63" style="height: 15pt; width: 92pt;" height="20" width="123">Column Heading A</td> <td class="xl63" style="border-left: medium none; width: 89pt;" width="118">column heading b</td> <td class="xl63" style="border-left: medium none; width: 87pt;" width="116">column heading c</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="border-top: medium none; height: 15pt;" height="20">81</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">02/16/10</td> <td class="xl66" style="border-top: medium none; border-left: medium none;">data</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="border-top: medium none; height: 15pt;" height="20">81</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">02/16/10</td> <td class="xl66" style="border-top: medium none; border-left: medium none;">data</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="border-top: medium none; height: 15pt;" height="20">86</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">02/16/10</td> <td class="xl66" style="border-top: medium none; border-left: medium none;">data</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="border-top: medium none; height: 15pt;" height="20">86</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">02/16/10</td> <td class="xl66" style="border-top: medium none; border-left: medium none;">data</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="border-top: medium none; height: 15pt;" height="20">86</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">02/16/10</td> <td class="xl66" style="border-top: medium none; border-left: medium none;">data</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="border-top: medium none; height: 15pt;" height="20">87</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">02/16/10</td> <td class="xl66" style="border-top: medium none; border-left: medium none;">data</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="border-top: medium none; height: 15pt;" height="20">87</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">02/16/10</td> <td class="xl66" style="border-top: medium none; border-left: medium none;">data</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="border-top: medium none; height: 15pt;" height="20">87</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">02/16/10</td> <td class="xl66" style="border-top: medium none; border-left: medium none;">data</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="border-top: medium none; height: 15pt;" height="20">92</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">02/16/10</td> <td class="xl66" style="border-top: medium none; border-left: medium none;">data</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="border-top: medium none; height: 15pt;" height="20">92</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">02/16/10</td> <td class="xl66" style="border-top: medium none; border-left: medium none;">data</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="border-top: medium none; height: 15pt;" height="20">92</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">02/16/10</td> <td class="xl66" style="border-top: medium none; border-left: medium none;">data</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="border-top: medium none; height: 15pt;" height="20">96</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">02/16/10</td> <td class="xl66" style="border-top: medium none; border-left: medium none;">data</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="border-top: medium none; height: 15pt;" height="20">96</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">02/16/10</td> <td class="xl66" style="border-top: medium none; border-left: medium none;">data</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="border-top: medium none; height: 15pt;" height="20">96</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">02/16/10</td> <td class="xl66" style="border-top: medium none; border-left: medium none;">data</td> </tr> </tbody></table>