Automate calculation in different sheets

Dear forum,

As I'm new here, pls forgive things a may not do according to forumrules.

I generate through out the year lots of Excelfiles. You can see one in the example.

The sheet "Tellingen" is the original one. This is what I do and would like to automate. Is this possible?
- Add collum "Betrouwbaarheidheid" as % in sheet "tellingen"
- fill in formula =ALS(G3<>"";ALS.FOUT(MAX(0;1-(ABS(H3-G3)/G3)*1);0);"")
- Fill all the rows
- Add sheet "Locatie"
- Add pivot table
- Add sheet "voorraad"
- Add formula =ALS(B4<>"";ALS.FOUT(MAX(0;1-(ABS(C4-B4)/B4)*1);0);"")
- Fill all the rows

Hepl would be appriciated.

Regards,

Gijs

And the results of "eindtotaal" I put in a different Excelsheet to make a graph

Test.xlsx

Here is an option for you.

Please Login or Register  to view this content.

Thank you Maniacb for your quick response!

As I am a complete noob on Excel, would it be possible for you for you to guide me into the direction how to use this in the testfile?
Maybe you can insert it there so I can understand how it is used?

Many thanks,

Gijs

Here is the file with the code embedded. I would use this file as a template where once you open it, save the file with a new name, copy and paste in the data in the Telligen tab, then run the code by pressing ctrl-g. I can also rewrite it so that the code is saved in your personal file(always opens with excel in the background) so that you can run the code and select a file to apply the update to. Let me know.