How to Link a horizontal row of data to a column in another wrksh.

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

Guest

I wou ldlike to know if there is an easy way to link a horizontal row of data
to a column of data in another worksheet easily. Currently I have to link one
cell at a time. There must be an easier way. I don't want to just cut and
copy the data. I need it to me linked.
 
On Sheet2 I have in column A a set of numbers 86,72,54....
In cell A10 of Sheet1 I entered =INDIRECT("Sheet2!A"&COLUMN()), copied it
across the row and got 86, 72, 54 ....
If I started in cell F20, I need =INDIRECT("Sheet2!A"&COLUMN()-5)

Hope this is useful
 
You must log in or register to reply here.

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
Excel Help to copy information from one row at a time to another sheet 1
Excel 2003: Linking a whole row or column to another worksheet 5
How to Convert same horizontal row to vertical row in Excel? 3
Auto Fill formula from a column to row 1
Can you extend a formula horizontally while the data is vertical 3
fixed links to another workbook 4
copying/dragging a formula to adjacent cells in Excel 1

Back
Top