Home |
Search |
Today's Posts |
#1
|
|||
|
|||
auto filling columns from rows
Hi there
How can I auto fill a series of values that equals a series of cells from another sheet? The cells I want the information to come from a row in another sheet and are going into a column. the references of the host cell are '!AH$9 when I fill down using the plus sign at the bottom corner it just copies this reference to each cell instead of filling the values '!AI$9 then '!AJ$9 etc. |
#2
|
|||
|
|||
Ken,
Try taking the dollar signs out before you copy the formula. The dollar signs make the formula absolute, which means that no matter where you copy it to, you'll always be referencing the same cell. This is fine where yu want to, for example, always reference one cell in a formula that might, for example, contain a currency conversion factor that you want to apply to a range of cells, but not, I suspect, in what you're trying to do. Hope this helps Pete "Ken" wrote: Hi there How can I auto fill a series of values that equals a series of cells from another sheet? The cells I want the information to come from a row in another sheet and are going into a column. the references of the host cell are '!AH$9 when I fill down using the plus sign at the bottom corner it just copies this reference to each cell instead of filling the values '!AI$9 then '!AJ$9 etc. |
#3
|
|||
|
|||
One way
Assuming in Sheet1, H9:K9 contains the values: 1,2,3,4 In Sheet2 ------------- Put in any starting cell, say A2: =OFFSET(Sheet1!$H$9,,ROWS($A$1:A1)-1) A2 will return the same as: =Sheet1!H9 i.e. the value of 1 Copy A2 down to A5 As you copy down, A3 will return the same as: =Sheet1!I9 A4 will return the same as: =Sheet1!J9 A5 will return the same as: =Sheet1!K9 i.e. A2:A5 will return the values: 1,2,3,4 from Sheet1's H9:K9 Adapt to suit -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "Ken" wrote in message ... Hi there How can I auto fill a series of values that equals a series of cells from another sheet? The cells I want the information to come from a row in another sheet and are going into a column. the references of the host cell are '!AH$9 when I fill down using the plus sign at the bottom corner it just copies this reference to each cell instead of filling the values '!AI$9 then '!AJ$9 etc. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing problems with columns and rows | Excel Discussion (Misc queries) | |||
Auto update entire columns / rows??? | Excel Worksheet Functions | |||
Can I rotate excel sheets so columns are rows & vice-versa (i.e.. | Excel Discussion (Misc queries) | |||
Convert multiple columns to rows | Excel Worksheet Functions | |||
interchange columns with rows | Excel Discussion (Misc queries) |