Transfer, populate and calculate data between excel sheets.

Closed
D Kos - 12 Oct 2015 à 19:02
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 16 Oct 2015 à 13:34
Hello,



I want to be able to input data daily onto the first sheet of my excel file for six different things. I then want to have a separate sheet for each thing that will then show the daily value inputted and then calculate a weekly, monthly and quarterly average for each individual tab. How can I do this?
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
16 Oct 2015 à 13:34
create a entry sheet
create a macro that will take information from entry sheet into specific sheet
have formula to calculate what you want