Hi,

What does your data look like on sheet1 and what do you want it to look like
on sheet2. Normally we use 1. Paste Special, Transpose, 2. The TRANSPOSE
function, 3. The OFFSET function, the INDIRECT, or INDEX functions.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Rich" wrote:

I've transposed the information from one worksheet to a second worksheet in
order to see the information linearly. The cells are referenced directly,
but in the original document, everything is in the same line.

Basically, I want all the cells in rows 2-8 of the new worksheet to be
referenced to row 2 of the old worksheet; rows 9-15 of the new to be
referenced to row 3 of the old, etc. When I copy/paste, instead of using row
3 (of the old), it uses row 9. Same goes when I try to use row 4, it uses
row 16. Is there any way to preserve that?

If more clarification is needed, I can do so, or even provide a link to the
file of what I'm trying to do.