Automating a sheet using another sheet, can you please help?

To summarize my purpose of this is to make the user able to generate the whole analysis by just copying new data for any club/room.

So if a user wants to populate modified data, we want the “Aux” sheet to populate automatically using the "ARS" sheet, specific columns would be column A (Datecreation), B(TotalCount), and drag the formulas in C and D.



You will find the capacity model. I created a “Home” sheet to store some data to be use in the future. “Time Data” is now getting the information from the “ARS Data” and using the data from the “Home” sheet to create the averages.

Now, we should be able to create the graphics based on “Time Data”.

I linked the columns A and B in the AUX sheet to the ARS sheet now I need help to drag the formulas in C and D.

Can you please help me with this problem?

Thanks