I have the below table for logging out the samples sales reps give out. Theres an auto sum feature in the table that calculates the shipping, retail, and cogs value for each unit logged out. I want to have a new tab which just shows the show REP | RETAIL| COGS. [TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 610"]
<colgroup><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]REP[/TD]
[TD]FOR[/TD]
[TD="align: right"] Shipping Cost [/TD]
[TD]Oranges[/TD]
[TD]Cranberries[/TD]
[TD]Lemons[/TD]
[/TR]
[TR]
[TD]Joe[/TD]
[TD]Personal[/TD]
[TD="align: right"] $- [/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD]Josh[/TD]
[TD]Stop n Shop 51[/TD]
[TD="align: right"] $12.51[/TD]
[TD="align: right"]25[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Rob[/TD]
[TD]Personal[/TD]
[TD="align: right"] $- [/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]Joe[/TD]
[TD]Mr T's farm[/TD]
[TD="align: right"] $16.00[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]25[/TD]
[/TR]
[TR]
[TD]Rob[/TD]
[TD]Stop n Shop 32[/TD]
[TD="align: right"] $8.99[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD]Josh[/TD]
[TD]UTEP[/TD]
[TD="align: right"] $12.59[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]TOTALS[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"] $50.09[/TD]
[TD="align: right"]62[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]53[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]RETAIL AMT[/TD]
[TD="align: right"] $50.09[/TD]
[TD="align: right"] $620.00[/TD]
[TD="align: right"] $144.00[/TD]
[TD="align: right"] $397.50[/TD]
[/TR]
[TR]
[TD]COG[/TD]
[TD][/TD]
[TD="align: right"] $50.09[/TD]
[TD="align: right"] $206.46[/TD]
[TD="align: right"] $70.40[/TD]
[TD="align: right"] $58.30[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
<tbody>[TR]
[TD][TABLE="width: 610"]
<colgroup><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]REP[/TD]
[TD]FOR[/TD]
[TD="align: right"] Shipping Cost [/TD]
[TD]Oranges[/TD]
[TD]Cranberries[/TD]
[TD]Lemons[/TD]
[/TR]
[TR]
[TD]Joe[/TD]
[TD]Personal[/TD]
[TD="align: right"] $- [/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD]Josh[/TD]
[TD]Stop n Shop 51[/TD]
[TD="align: right"] $12.51[/TD]
[TD="align: right"]25[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Rob[/TD]
[TD]Personal[/TD]
[TD="align: right"] $- [/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]Joe[/TD]
[TD]Mr T's farm[/TD]
[TD="align: right"] $16.00[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]25[/TD]
[/TR]
[TR]
[TD]Rob[/TD]
[TD]Stop n Shop 32[/TD]
[TD="align: right"] $8.99[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD]Josh[/TD]
[TD]UTEP[/TD]
[TD="align: right"] $12.59[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]TOTALS[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"] $50.09[/TD]
[TD="align: right"]62[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]53[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]RETAIL AMT[/TD]
[TD="align: right"] $50.09[/TD]
[TD="align: right"] $620.00[/TD]
[TD="align: right"] $144.00[/TD]
[TD="align: right"] $397.50[/TD]
[/TR]
[TR]
[TD]COG[/TD]
[TD][/TD]
[TD="align: right"] $50.09[/TD]
[TD="align: right"] $206.46[/TD]
[TD="align: right"] $70.40[/TD]
[TD="align: right"] $58.30[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]