Excel Question

[FunkyGibbon]

Does anyone know if you can transpose links to a row of cells?

What I want to do is have a sheet where people input values in a number of horizontal row. (It's easier for them to use it that way)

On a other sheet I want this data as a number of vertical columns - makes it easier for me to do the analysis.

I want the cells on the second sheet to be links to the first. I can do this cell by cell, but when I try to do it globally - if I tick the transpose option in "Paste Special" the Link option is greyed out.

Any ideas?

TIA

[Big Al.]

Not sure if I can assist, any chance of getting a copy of your spead sheets?

[ATG]

Try using the index() function. You pass it a range of cells and then the coordinates o fthe value in the range you want to return. If you shove a list of integers 1 to n in a column on your analysis sheet you can use that as the column index for the user-input data.

[Jay-Aim]

wouldn't it quicker to just use drag and drop?