Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 13th 09, 10:13 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2008
Posts: 21
Default 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   Report Post  
Old January 13th 09, 10:36 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2007
Posts: 2,480
Default 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   Report Post  
Old January 13th 09, 12:29 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2008
Posts: 21
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy then Paste with a transpose SteveM Excel Discussion (Misc queries) 2 November 29th 07 06:01 PM
copy&paste 28 individual files into one file/28 work sheets Yvez T.T. Constance Excel Worksheet Functions 1 November 18th 07 10:54 AM
how to create a copy/paste special/transpose macro? [email protected] Excel Discussion (Misc queries) 6 August 8th 07 06:07 AM
Copy / Paste - Kind of Transpose Carl Jarvis New Users to Excel 1 October 11th 05 04:27 AM
HELP....Is there a way to automate copy/paste special/transpose - Mel Excel Worksheet Functions 7 March 28th 05 11:17 PM


All times are GMT +1. The time now is 07:56 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017