View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bioyyy bioyyy is offline
external usenet poster
 
Posts: 22
Default Macro for averaging

Hello All:

Would you please help with macro to average all the data and put in a new
sheet.

1/ "Rawdata" sheet contain all the data
2/ Average 3 rows starting from row 2 to 2000 (let say average row 2 to 4,
and 5-7, so on)
3/ Copy and paste in a new sheet lets called "Summary" at column 3 row2
4/ Delete all the blank rows

Thanks for all your help!