Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ranking query | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions |