Ok I have created a data sheet for scoring canidates on a test. At the end of the test i would like to give them there average score based on all 3 judges.

I have created individual judging section where each judge can assess a canidate independantly and also see how that affects the canidates average score.

I have also made a sheet that will average the individual judges scores to make up a average for each possible gradeded technique.

I am intending on making a sheet that can propigate this data to a single page as opposed to printing 6 pages with one row accross the top.

I do not wish to havto manually put in a cell address like " ='Canidates Score Avg HORIZ'!D2" for each cell manually.

I have tried to transpose it to vertical so i could use the autofill handle and just drag down. = failed

So i have 3 sheets so far

Yudanja 1.1 = for judges
Canidates Score Avg HORIZ = averaged data for each canidate with headers
Canidates printable = template i would like to try and fit the data to one page.

Is there any easy way to get the data where i want it to go without plugging in each cell manually? im open to other layout options.

My biggest thing is they get all the data with only there score not all the canidates scores and that it fits on one page and is readable and not all mashed together. i would greatly appreciate any help in being pointed in the right direction.

I dont do much with macros or script but im willing to try.

heres link to what i have via dropbox

https://www.dropbox.com/s/kawynxc635...01.1.xlsx?dl=0