possible to auto-fill down horizontal data?

[excelRookie06]

Hello,

I have data that goes accross my collumns horizontally (output from another program), which I need to re-list vertically.

So I have my first cell listed vertically equal to the first cell listed horizontally.... Is it possible to somehow auto-fill DOWN from the first cell and pick up the data going horizontally accross the columns?

By the way, I need the vertical data to "equal" the horizontal cells, so that I can reference the same cells everytime I output from the other program.

Thanks!

[Carim]

Hi,

Edit Copy Edit PasteSpecial Transpose

HTH
Carim

[excelRookie06]

Forgot to mention the cells I'm referencing are on another sheet in the same workbook.

I'm getting a #REF! Error because it's referencing from the sheet I'm pasting to rather than the sheet I'm copying from.

But thanks, I think I have an idea to make it work with this

[Carim]

You are welcome ...

Carim