copy, paste and transpose formula's into work sheets
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.
--
Regards
Roger Govier
"Derro" wrote in message
...
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.
|