Transfer, populate and calculate data between excel sheets.

Closed

D Kos - Oct 12, 2015 at 07:02 PM
rizvisa1 Posts 4479 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?

Transfer, populate and calculate data between excel sheets.
Transfer data from one excel worksheet to another automatically - Guide
Excel date format dd.mm.yyyy - Guide
Free fire transfer - Guide
How to calculate vat in excel - Guide
How to screenshot excel sheet - Guide

1 reply

Answer 1 / 1

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
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

Similar discussions

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

How to calculate position (1st,2nd,3rd) in excel....?

formulas for 1st and 2nd position in class

Calculation of positions in excel

Similar discussions

Subscribe To Our Newsletter!