Column to row linking

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Moe Myers - 21 Mar 2004 04:18 GMT

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?

Signature

Phil

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

Reply to this Message

Bill Manville - 21 Mar 2004 09:07 GMT

> 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

Reply to this Message

Moe Myers - 21 Mar 2004 23:04 GMT

Thank you, Bill, that did the trick!.

Phil

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

> > How would I go about changing the default behavior of the
> > Autofill feature to read by column instead of row?
[quoted text clipped - 16 lines]
> MVP - Microsoft Excel, Oxford, England
> No email replies please - respond to newsgroup

Reply to this Message