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

J

JenTutte

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.
 
B

Bernard Liengme

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
 
Top