Macro that counts the Nbr of Teams and calculate the total & Ratio
 

Hello,

Would it be possible to develop a macro that counts the number of teams
listed on the summary page (Sheet1) of the report and add a new sheet named
Total. This new sheet (Total) will consist of three columns:
Team Total Ratio
00 50 1.94 %
01 30 0.30%
02 17 0.17%
Grand Total: 97

If it is something feasible, please help me with the routine needed in order
to make it possible.

Thanks,