Jump to content


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.

Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.


Excel 2010, help making macros

  • Please log in to reply
No replies to this topic

#1 Gpage


  • Members
  • 1 posts
  • Local time:12:47 AM

Posted 07 July 2016 - 11:13 AM

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.



BC AdBot (Login to Remove)



0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users