copying cell formulas: from a colums to rows

  • Thread starter Thread starter Johann
  • Start date Start date
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
 
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
Click to expand...


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
Click to expand...

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
Click to expand...

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.
 
Back
Top