Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with formula to set up multiple transposing 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 configeration containing cells with text headings, and cells with financial data formula's that 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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
See/work with multiple sheets at the same time | Excel Discussion (Misc queries) | |||
how to print multiple work sheets using vba | Excel Discussion (Misc queries) | |||
how to sum cells from multiple work sheets | Excel Worksheet Functions | |||
Counting dates in multiple work sheets and work books | Excel Discussion (Misc queries) | |||
Multiple Work Sheets | Excel Worksheet Functions |