Macro or help with populating data after inputting

Closed
Posts
2
Registration date
Tuesday October 20, 2015
Status
Member
Last seen
October 20, 2015
-
 Blocked Profile -
I would like to be able to enter information into the sheet shown daily (therefore every day different and new data will be inputted into this main sheet for each of the data columns). I would then like this data to transfer over to another sheet (one sheet for each name shown). I want the data to populate for each day and then create a weekly average, monthly average, quarterly, and so on. I am having a lot of trouble understanding how this can be done and keep populating over and over again after new data is inputted. Help on this would be very much appreciated. Thanks!

2 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
769
you can do this via macro
you can use macro recorder to get an idea how the macro would look like by recording your actions
Posts
2
Registration date
Tuesday October 20, 2015
Status
Member
Last seen
October 20, 2015

Hi and thank you for your response! I have never used macros before in excel so I am completely lost. Do you have any specific tips on how I can develop this file by any chance?

Thanks

If I may?

If you are not familiar with macros, then just think of them as a MOUSE RECORDER. You press record, and from that click on, the macro records every single click, drag, copy, cut and paste! Do not forget to end the recording!