Previous Topic Next Topic

Transfer, populate and calculate data between excel sheets.

Closed
D Kos - Oct 12, 2015 at 07:02 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Oct 16, 2015 at 01:34 PM
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

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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response
calculating fuel surcharge
Nancy -
xpcman -

1 response