I have 2 sheets and on the first one I have used a function to calculate the
average of each successive group of 10 values. Then I want to take all of
these values without the gaps that are present between calculated averages
and have them placed in the second sheet. My reference to sheet 1 is

=testfunc!B1

This value will be the first in the column of average values. I wanted to
know if there was a way for me to get the value of testfuncB11 into the
second cell in my column of averages in sheet 2 as this would be the cell my
next calculated average is in?