transposing and linking cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to transpose and link the contents of cells from one worksheet onto
another worksheet but I can't seem to do this with the paste special command.
If I select transpose it greys out link cells. Thanks in advance.
 
Assuming source data is vertical in Sheet1 A1:A99
In sheet2 row1 column A, enter:
=INDEX(Sheet1!A1:A99;COLUMN())
then copy to the right

HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to transpose data (Row to column) without losing the cell link 3
Transpose with linked data 6
how do I link data between worksheets when data is transposed? 3
Auto Fill formula from a column to row 1
Transpose Microsoft Query 2
Transposing 3
"Paste Special / Transpose" problem 3
Transpose Large Column to Row 2

Back
Top