Need some help with macros. We have a sheet where we enter numbers in daily and then at the end of the week manually transfer them over to a different sheet to show the weekly average. I can do basic macros like clearing a field but this is beyond me. I attached two pictures of what I am doing. One shows the sheet we enter the daily info into and the second is the weekly one. Right now on the weekly one it is by weeks. Ideally I would like a clear button on each page that the macro would tell it to input into the corresponding slot on the weekly results page and then clear the sheet for the next week. Any help would be appreciated. If anyone could point me to somewhere on the web to do advanced macros or to get help with them if no one on here knows that would be great too. Thank you.
https://pix.sfly.com/sCZO0Z Where I enter the info
https://pix.sfly.com/nyX_dx Where I want the info to go at the end of the week when a clear button is pressed.
Thank you much.