Multi-sheet autofill

[RichH]

I have information (numbers) ranging on Sheet1A1 to Sheet1GS1.

I would like to copy these numbers onto Sheet2 ranging from A1 to A150.

I enter =Sheet1A1 on Sheet2A1, and then enter =Sheet1B1 on Sheet2A2.

When I try to Autofill, I would like the results to show =Sheet1C1 on
Sheet2A3 all the way down Sheet2. However, when I try to autofill the
program will not keep the pattern I have written above. What can I do to
make the autofill follow my pattern?

[Gord Dibben]

Rich

Non-linked........Copy Sheet1 row 1 and Paste Special>Transpose to Sheet2 A1

Linked.............In Sheet2 A1 enter this formula.

=INDEX(Sheet1!$A$1:$GS$1,ROWS($1:1)) drag/copy down to A150

Note: A1:GS1 is 201 columns so you may want to copy down that far.


Gord Dibben Excel MVP


On Mon, 19 Dec 2005 13:43:25 -0800, "RichH" <[email protected]>
wrote:

>I have information (numbers) ranging on Sheet1A1 to Sheet1GS1.
>
>I would like to copy these numbers onto Sheet2 ranging from A1 to A150.
>
>I enter =Sheet1A1 on Sheet2A1, and then enter =Sheet1B1 on Sheet2A2.
>
>When I try to Autofill, I would like the results to show =Sheet1C1 on
>Sheet2A3 all the way down Sheet2. However, when I try to autofill the
>program will not keep the pattern I have written above. What can I do to
>make the autofill follow my pattern?

[RichH]

That worked perfectly! Thank you very much for your quick response!!!

"Gord Dibben" wrote:

> Rich
>
> Non-linked........Copy Sheet1 row 1 and Paste Special>Transpose to Sheet2 A1
>
> Linked.............In Sheet2 A1 enter this formula.
>
> =INDEX(Sheet1!$A$1:$GS$1,ROWS($1:1)) drag/copy down to A150
>
> Note: A1:GS1 is 201 columns so you may want to copy down that far.
>
>
> Gord Dibben Excel MVP
>
>
> On Mon, 19 Dec 2005 13:43:25 -0800, "RichH" <[email protected]>
> wrote:
>
> >I have information (numbers) ranging on Sheet1A1 to Sheet1GS1.
> >
> >I would like to copy these numbers onto Sheet2 ranging from A1 to A150.
> >
> >I enter =Sheet1A1 on Sheet2A1, and then enter =Sheet1B1 on Sheet2A2.
> >
> >When I try to Autofill, I would like the results to show =Sheet1C1 on
> >Sheet2A3 all the way down Sheet2. However, when I try to autofill the
> >program will not keep the pattern I have written above. What can I do to
> >make the autofill follow my pattern?
>