Home |
Search |
Today's Posts |
#1
|
|||
|
|||
copying formulas from worksheet to worksheet
I need to copy a row of cells from one worksheet to a column of another
worksheet. I want it to reference the cells listed in the row of one worksheet to the column of the other worksheet. I found out how to do the reverse - =offset('worksheet name'!$a$1,0,row(1:1)-1) - but it doesn't work for copying rows to columns? Can you help? |
#2
|
|||
|
|||
Think the way that your Q was phrased,
an adaptation of the formula you posted should work Assume you have in Sheet1,in B2:E2, the numbers: 1,2,3,4 In Sheet2 ------------ Put in the start-cell, say B2? : =OFFSET(Sheet1!$B$2,,ROWS($A$1:A1)-1) Copy B2 down to B5 This will return the numbers 1 - 4 from Sheet1's B2:E2 Now supposing you want the "reverse", i.e. dynamically link/transpose what's in a column in one sheet, "row-wise" in another sheet Let's say you have in Sheet1, in A2:A5, the letters: a,b,c,d In a new Sheet3 --------------- Put in the start-cell, say B1? : =OFFSET(Sheet1!$A$2,COLUMNS($A$1:A1)-1,) Copy B1 across to E1 This will return the letters: a - d from Sheet1's A2:A5 -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "yesbob" wrote: I need to copy a row of cells from one worksheet to a column of another worksheet. I want it to reference the cells listed in the row of one worksheet to the column of the other worksheet. I found out how to do the reverse - =offset('worksheet name'!$a$1,0,row(1:1)-1) - but it doesn't work for copying rows to columns? Can you help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2002 - copying formulas to another worksheet | Excel Discussion (Misc queries) | |||
Replicating Formulas with Various Worksheet References | Excel Worksheet Functions | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
hyperlinks and copying a worksheet | Excel Worksheet Functions |