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

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.

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

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"JenTutte" wrote in message
...
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.