Hi
I know this topic has already been raised but I am not sure I understood any
of the answers. I am a novice where functions like OFFSET and INDEX are
concerned.

What I would like to do is transpose horizontal data from Sheet1! row
$C$4:$CB$4 and place it in Sheet2! column $G$10:$G$61 while retaining the
links to the original data in Sheet1!- how do I do that? What is the formula
which will produce this result.

Regards
Neil