Linking cells between worksheet - from column to row

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

Guest

Trying to copy range of data (down) from a column in worksheet A and link it
in a row (across) in worksheet B. Link won't work in a range of data and
transpose isn't working (or I'm not doing something right.
 
Assuming source data in sheet: A,
data running in A1 down

In sheet: B,
Place in any start cell, say, in B2:
=INDEX(A!$A:$A,COLUMNS($A:A))
Copy B2 across as required to return the dynamic transpose
of the source data in "A"
 
Copy your range in worksheet A. Select a cell on worksheet B , right click,
Paste Special , Traspose, click OK
 

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

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel VBA 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Excel 2003 Macro - Finding rows with data to copy 1
Linking cell ranges between rows and columns 1
Is there a way to do a "lookup" and change the orientation of the 6
search function 2
Linking worksheet and multiple cells 1

Back
Top