Greetings,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><o
> </o
>
I need to link a column of numbers in one worksheet to a row of another worksheet. We tried the transpose feature but that transposed static values instead of a live link. Here is what I’m working with.
<o
> </o
>
Worksheet 1<o
></o
>
A B C D E F .<o
></o
>
1 25 . <o
></o
>
2 38 .<o
></o
>
3 1 .<o
></o
>
4 10 .<o
></o
>
5 35 .<o
></o
>
6 58 <o
></o
>
<o
> </o
>
<o
> </o
>
<o
> </o
>
Worksheet 2<o
></o
>
A B C D E F .<o
></o
>
1 . <o
></o
>
2 .<o
></o
>
3 Amount =Sheet1!C1 =C2 =C3 =C4 =C5 .<o
></o
>
4 .<o
></o
>
5 .<o
></o
>
6 <o
></o
>
<o
> </o
>
Worksheet 1 has about 50 rows of numbers and I’ve got a total of 70 similar worksheets to link to Worksheet 2. In B3 above, I’ve tried typing =$C1 and =C1.
<o
> </o
>
After linking B3 to C1 in worksheet 1, I try to use the drag handle to continue the series. But what ends up happening is Excel copies =C1, =D1, =E1. What I need Excel to do is fill in =C1, =C2, =C3 when I use the drag handle across the row.
<o
> </o
>
Any thoughts?
<o
> </o
>
Thank you.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com




I need to link a column of numbers in one worksheet to a row of another worksheet. We tried the transpose feature but that transposed static values instead of a live link. Here is what I’m working with.
<o


Worksheet 1<o


A B C D E F .<o


1 25 . <o


2 38 .<o


3 1 .<o


4 10 .<o


5 35 .<o


6 58 <o


<o


<o


<o


Worksheet 2<o


A B C D E F .<o


1 . <o


2 .<o


3 Amount =Sheet1!C1 =C2 =C3 =C4 =C5 .<o


4 .<o


5 .<o


6 <o


<o


Worksheet 1 has about 50 rows of numbers and I’ve got a total of 70 similar worksheets to link to Worksheet 2. In B3 above, I’ve tried typing =$C1 and =C1.
<o


After linking B3 to C1 in worksheet 1, I try to use the drag handle to continue the series. But what ends up happening is Excel copies =C1, =D1, =E1. What I need Excel to do is fill in =C1, =C2, =C3 when I use the drag handle across the row.
<o


Any thoughts?
<o


Thank you.