I am creating an Excel sheet that summarizes data from other sheets in a
workbook. Each column of data on the summary sheet represents a certain cell
of each of the other sheets. (i.e., the data from cell C6 of sheet 1 appears
in cell A1 of the summary page, the data from cell C6 of sheet 2 appears in
cell A2 of the summary page,...) So, the formula I am entering in cell A1 of
the summary page is

='sheet 1'!C6

My question is: How can I fill the rest of column A of the summary page
with the data I want without having to actually type in every formula for
every cell? I would like the formula for cell A2 of the summary page to be

='sheet 2'!C6

and so on. The fill handle does not seem to work even if I use C$6 instead
of C6.

See
http://www.rondebruin.nl/linksum.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"chichi0918" <(E-Mail Removed)> wrote in message news:1D06C867-3828-4620-82B4-(E-Mail Removed)...
>I am creating an Excel sheet that summarizes data from other sheets in a
> workbook. Each column of data on the summary sheet represents a certain cell
> of each of the other sheets. (i.e., the data from cell C6 of sheet 1 appears
> in cell A1 of the summary page, the data from cell C6 of sheet 2 appears in
> cell A2 of the summary page,...) So, the formula I am entering in cell A1 of
> the summary page is
>
> ='sheet 1'!C6
>
> My question is: How can I fill the rest of column A of the summary page
> with the data I want without having to actually type in every formula for
> every cell? I would like the formula for cell A2 of the summary page to be
>
> ='sheet 2'!C6
>
> and so on. The fill handle does not seem to work even if I use C$6 instead
> of C6.

Or see
http://www.rondebruin.nl/summary.htm



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Ron de Bruin" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> See
> http://www.rondebruin.nl/linksum.htm
>
> --
>
> Regards Ron de Bruin
> http://www.rondebruin.nl/tips.htm
>
>
> "chichi0918" <(E-Mail Removed)> wrote in message news:1D06C867-3828-4620-82B4-(E-Mail Removed)...
>>I am creating an Excel sheet that summarizes data from other sheets in a
>> workbook. Each column of data on the summary sheet represents a certain cell
>> of each of the other sheets. (i.e., the data from cell C6 of sheet 1 appears
>> in cell A1 of the summary page, the data from cell C6 of sheet 2 appears in
>> cell A2 of the summary page,...) So, the formula I am entering in cell A1 of
>> the summary page is
>>
>> ='sheet 1'!C6
>>
>> My question is: How can I fill the rest of column A of the summary page
>> with the data I want without having to actually type in every formula for
>> every cell? I would like the formula for cell A2 of the summary page to be
>>
>> ='sheet 2'!C6
>>
>> and so on. The fill handle does not seem to work even if I use C$6 instead
>> of C6.