Macros
 

I want to be able to enter daily data into a spreadsheet with a column for
weekly average which is not a problem. I then want this weekly average to
populate into another monthly worksheet , clear the daily worksheet for next
week data and each week enter the new data into the monthly worksheet on the
next line. Is there a macro that will do this?
Thanks