copy, paste and transpose formula's into work sheets

[Derro]

Hi Excel Gu-ru's. I am using Excel 2007. Could any one please help

an old bloke who is out of his depth. I have multiple work sheets of

prime and slave configuration containing cells with text headings, and

cells with financial data formula's. All need to be set up with the

same headings etc. A further requirement is that when at a latter

date I wish to change headings or data in the prime sheet, the

corresponding headings and data in the slave work sheets need to

change automatically along with the prime sheet. As there are many

cells to initially set up it would save many hours if I could use a

formula that I could paste and fill. A further complication is that the

headings and data in the prime sheet will be in columns and need to

be transposed when pasting and filling to cells that are in rows in the

other slave work sheets. Any help or suggestions would be

appreciated.

 

[Roger Govier]

Hi

Assuming that you mean you want cells A1:M1 of Sheet1 to appear as cells
A1:A13 in Sheet2, and the same for each successive row of Sheet 1 then in
cell A1 of Sheet2 enter
=INDEX(Sheet1!$1:$65536,COLUMN(),ROW())
Copy down and across as far as required.

 

[Derro]

Thanks Rodger I will give it a go

Hi

Assuming that you mean you want cells A1:M1 of Sheet1 to appear as cells
A1:A13 in Sheet2, and the same for each successive row of Sheet 1 then in
cell A1 of Sheet2 enter
=INDEX(Sheet1!$1:$65536,COLUMN(),ROW())
Copy down and across as far as required.