Linking data from Rows to columns in seperate worksheets

G

Guest

I cannot find a way to quickly link data in rows from one worksheet to
columns in another without using the hold = button select cell method-- which
is very slow. I dump data from a survey tool into excel. It is displayed in
rows. I would like to link that data to columns in another worksheet so that
I can line up survey results by group side by side. The questions would run
down Column A, the answers would run down columns B, C, D -- so i can do a
side by side comparison with the data. What formula will allow me to do this
quickly?
 
T

T. Valko

Suppose in Sheet1 you have data in B1:E1 and you want to link this data to
Sheet2 in B2:B5.

Enter this formula in Sheet2 B2 and copy down as needed:

=INDEX(Sheet1!B$1:E$1,ROWS($1:1))
 

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

matching & combining data from seperate worksheets 2
Compare identifier columns from 2 sheets - remove rows that are dups 2
VBA - retrieve data on last create named range from previous inserted named range 0
Linking Columns between worksheets 6
linking data from one worksheet to another 1
combine columns of data from multiple worksheets into one 7
linking two worksheets in the same workbook 6
Transferring only certain rows to seperate worksheet 8

Top