Originally Posted by p45cal

As long as the data in each tab is laid out in a similar way, that is with 7 columns next to each other:


Attachment 21110


then as long as you have a column somewhere with the goal ranges, like:


Attachment 21111 and you adjust the ranges referred to in the function to those cells, there should be no problem.


Note that the function doesn't use the first half results at all (columns 3 and 4 of the referred-to source data), so they could be blank.