View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jurassien Jurassien is offline
external usenet poster
 
Posts: 24
Default 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,