Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Links
how do I super-quickly link a row in one sheet to the corresponding column in
another sheet (without having to do it manually)? I create a transposed array, but then cannot copy it down... dont know if this is the best? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Links
From your wording, I can't follow which is to be the "source" data.
Say Sheet1, Row1 data is the source. To link that row of data to a column on Sheet2, enter this formula anywhere, and copy down as needed: =INDEX(Sheet1!$1:$1,ROWS($1:1)) To make a column on Sheet2 the "source" (say ColumnF), enter this formula anywhere, and copy across as needed: =INDEX(Sheet2!$F:$F,COLUMNS($A:A)) -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Walter" wrote in message ... how do I super-quickly link a row in one sheet to the corresponding column in another sheet (without having to do it manually)? I create a transposed array, but then cannot copy it down... dont know if this is the best? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update links box gives Continue or Edit Links dialog | Excel Discussion (Misc queries) | |||
Edit Links: Changing links on a protected worksheet | Excel Discussion (Misc queries) | |||
Links: Re-establishing Links | Excel Discussion (Misc queries) | |||
EXCEL - LINKS cannot easily get list of all links & names in book | Excel Worksheet Functions | |||
can't update links...can't find links | Excel Discussion (Misc queries) |