Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy, paste and transpose formula's into work sheets
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy, paste and transpose formula's into work sheets
Thanks Rodger I will give it a go
"Roger Govier" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy then Paste with a transpose | Excel Discussion (Misc queries) | |||
copy&paste 28 individual files into one file/28 work sheets | Excel Worksheet Functions | |||
how to create a copy/paste special/transpose macro? | Excel Discussion (Misc queries) | |||
Copy / Paste - Kind of Transpose | New Users to Excel | |||
HELP....Is there a way to automate copy/paste special/transpose - | Excel Worksheet Functions |