| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| the contents of a tabbed spreadsheet in one sheet | Excel Discussion (Misc queries) | |||
| Multiple sheet data summary | Excel Worksheet Functions | |||
| How do I control fields tabbed to on protected sheet? | Excel Discussion (Misc queries) | |||
| how to copy a cell with formula from sheet 1 (data is all vertical) into sheet 2 | Excel Worksheet Functions | |||
| How do I make a sheet that combines all tabbed sheets & update as. | New Users to Excel | |||
Linear Mode
