Calculating 8 Threads (Inefficient Code)

[Fugdkn]

As of current, the excel workbook is fine, but when I start adding more columns, that's when issues started to arise. Basically, every Week (the week I have shown is Week 28) will be copied an pasted until we reach Week 52. The same is true for both sheets. The original "Reps (Per Week)" sheet actually is supposed to have loads of stuff in there per Week, but I had to get rid of that due to sensitive information, but it would have been say 15 columns per week, each involving multiple calculations in a given cell, some of which were quite complex (it shouldn't matter too much though because that sheet always works at a good speed, even with 30+ weeks, that is to say, it was only when I added the Reps Adjustment sheet that I started to get problems).

The labels may not make as much sense as they should ideally, but once again, there was sensitive info (for the company I work at). Basically, I just need to know what part of the code in my "Reps Adjustment Sheet" is likely causing issues or volatility.

I should note that I actually changed one aspect of it already, so maybe it's already fixed, but basically I switched out a column that had "=SUMIF($B:$B,E4,J:J)" for each row (with E4 adjusting as it would) for a pivot table because I realised that a pivot table made more sense.

I hope what I have said makes sense. Basically, the "Reps per Adjustment Sheet is causing major slowdown issues when multiple "weeks" are made (looking at the file I have attached should make things clearer).

EDIT - The Reps Adjustment Sheet is basically taking a set of exercises (for a given bodypart) and ensuring that any bodypart that hasn't been given enough reps (1008), has a sufficient amount of reps added to it's exercises, in order of the "usefulness" of an exercise (basically, exercises that are higher in the list are seen as a better, so if a "body part" has two exercises, but they fall short of 1008 by 200, then 2/3 of the 200 should be allocated to the first (best) exercise, and 1/3 of the 200 should be allocated to the second (not as good) exercise (everything is rounded to meet multiples of 4). Really sorry for how weird the example seems. I am just trying to hide sensitive info. If this doesn't make enough sense, then I will rewrite it so that it can be understood more easily.