# copying cell formulas: from a colums to rows

J

#### Johann

In Sheet1 I have data in data in cells:
A1 B1 C1
A2 B2 C2
A3 B2 C3
A4 B4 C4
etc.

In Sheet2, I want to link:
row1: A1=sheet1!A4 A2=sheet1!B4 A3= sheet1!C4

How do can I automatically copy the formulas in row 1 to
the other rows so it will look like ?
row2: B1=sheet1!A4 B2=sheet1!B4 B3= sheet1!C4
row3: C1=sheet1!A4 C1=sheet1!B4 C1= sheet1!C4
row4: D1=sheet1!A4 D1=sheet1!B4 D1= sheet1!C4

Thanks,
Johann

P

#### Paul

Johann said:
In Sheet1 I have data in data in cells:
A1 B1 C1
A2 B2 C2
A3 B2 C3
A4 B4 C4
etc.

In Sheet2, I want to link:
row1: A1=sheet1!A4 A2=sheet1!B4 A3= sheet1!C4

Thanks,
Johann

I think you need to correct your post before anyone will be able to
understand what you want.
For example:
In Sheet2, I want to link:
row1: A1=sheet1!A4 A2=sheet1!B4 A3= sheet1!C4

But A1, A2 and A3 are in column A, not row 1. What do you mean?
And again:
How do can I automatically copy the formulas in row 1 to
the other rows so it will look like ?
row2: B1=sheet1!A4 B2=sheet1!B4 B3= sheet1!C4
row3: C1=sheet1!A4 C1=sheet1!B4 C1= sheet1!C4
row4: D1=sheet1!A4 D1=sheet1!B4 D1= sheet1!C4

I might assume you mean copy the formulas in column A to the other columns.
However, the formulas appear to be the same as each other!

You need to specify what you want accurately.