"Parameters" sheet has three strings in A6 - A8,
"Spread" sheet has every possible permutation of those strings in Cols A and B.
Starting in row 6, the Code should find the matching strings in "Parameters", copy the two values for each week in turn, post them into Cols X and Y, Col O then divides X by Y, and moves to next column and find the values for that week.
But it throws an error 1004 when it comes to calculating value of "j.Offsets"
Tried every permutation of brackets I can, but simply missing something obvious
K17 - V22 shows what the output should be.
Any suggestions, solutions or alternatives welcome as ever
Ochimus
Bookmarks