If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Column to row linking
I have a workbook whose data in columns on sheet1 (Year) need copied and
linked to rows on other sheets (Jan, Feb, Mar, etc.), and need updated when the data on the Year sheet is updated. I have done this with January by editing the cell references manually, but when I tried autofilling the data, the cell references ran by row (E7, F7, G7, etc.) instead of by column (E7, E8, E9, etc.). How would I go about changing the default behavior of the Autofill feature to read by column instead of row? -- Phil .................................................. .................. |
#2
|
|||
|
|||
Column to row linking
Moe Myers wrote:
How would I go about changing the default behavior of the Autofill feature to read by column instead of row? You can't do it using AutoFill. You could array-enter a formula to do it... Select the cells where you want the transposed data Type =TRANSPOSE( select the cells containing the original data Type ) and enter the formula using Ctrl+Shift+Enter It should end up looking something like this on the formula bar {=TRANSPOSE(Sheet1!A1:A12)} Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
#3
|
|||
|
|||
Column to row linking
Thank you, Bill, that did the trick!.
Phil .................................................. .................. "Bill Manville" wrote in message ... Moe Myers wrote: How would I go about changing the default behavior of the Autofill feature to read by column instead of row? You can't do it using AutoFill. You could array-enter a formula to do it... Select the cells where you want the transposed data Type =TRANSPOSE( select the cells containing the original data Type ) and enter the formula using Ctrl+Shift+Enter It should end up looking something like this on the formula bar {=TRANSPOSE(Sheet1!A1:A12)} Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
Thread Tools | |
Display Modes | |
|
|