How can i copy data from a tabbed working sheet to a summary sheet
I have cells in worksheets sheets Jan to Dec stored in columns that I wish to
have copied across to a summary sheet and store them in rows. Is it possible to do this? |
How can i copy data from a tabbed working sheet to a summary sheet
Select the range to copy
Edit|copy Select the top left corner of the range to paste Edit|paste special|click the transpose button. StephenF wrote: I have cells in worksheets sheets Jan to Dec stored in columns that I wish to have copied across to a summary sheet and store them in rows. Is it possible to do this? -- Dave Peterson |
All times are GMT +1. The time now is 06:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com