Forum Discussion
Solved
Linking Tabs to Sum
Hello! I'm not sure the best way to go about this project, so I was wondering if you all could help. I am trying to total the hours of each pay code and labor cost for each day not worked. Here...
That is not so difficult. If you want to work with a pivot table in the future, you will need the formula in column L because the shop information can only be found in the CC. The formula I wrote will also work in any other of your worksheets as long as you have the table CC with the same range CC!$A$3:$R$46 of data. If necessary you have to adapt it.
If you have the data then you need to select the data range and then create the pivot table. Try that out. It is not difficult. I'm sure there are many good documentations on the internet and YouTube on how it works.
You still have to make some settings so that it looks exactly like in my example. But with a little trial and error, you're sure to get it right.
I would suggest you to create what is called a UDF (User-defined-function) in VBA so you can use it in a formula like =FULLCOSTOF("ASSY N", 05/13/2022) and all the logic goes into VBA because of the complexity of it.
Once you have that formula working. You can create a regular table with all your shops and a period you want to analyze (say 05/13/2022- 11/25/2022), and use the formula to calculate the costs.
Once you have the costs populated into a column on that table you might create the pivot table for your report without problems.
If for some reason you believe it is too complex. I can definitely help you out with this. Here is my LinkedIn profile just in case
https://www.linkedin.com/in/custom-automations/
Once you have that formula working. You can create a regular table with all your shops and a period you want to analyze (say 05/13/2022- 11/25/2022), and use the formula to calculate the costs.
Once you have the costs populated into a column on that table you might create the pivot table for your report without problems.
If for some reason you believe it is too complex. I can definitely help you out with this. Here is my LinkedIn profile just in case
https://www.linkedin.com/in/custom-automations/