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

.................................................. ..................

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

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