| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy columns paste in rows
My task is to copy data from columns for eg. a2 to a10 and paste the values to
rows for eg. b2 to k2 of another worksheet. How to do this? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy columns paste in rows
A clue to help you. Copy the cells in the columnselect
destinationeditpastespecialtranspose -- Don Guillett Microsoft MVP Excel SalesAid Software "ezil" wrote in message ... My task is to copy data from columns for eg. a2 to a10 and paste the values to rows for eg. b2 to k2 of another worksheet. How to do this? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy columns paste in rows
Thanks
I have to do this task through a macro. Not directly from excel menu. "Don Guillett" wrote: A clue to help you. Copy the cells in the columnselect destinationeditpastespecialtranspose -- Don Guillett Microsoft MVP Excel SalesAid Software "ezil" wrote in message ... My task is to copy data from columns for eg. a2 to a10 and paste the values to rows for eg. b2 to k2 of another worksheet. How to do this? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy columns paste in rows
Turn on the macro recorder and see what you come up with.
Gord Dibben MS Excel MVP On Sun, 12 Aug 2007 07:12:08 -0700, ezil wrote: Thanks I have to do this task through a macro. Not directly from excel menu. "Don Guillett" wrote: A clue to help you. Copy the cells in the columnselect destinationeditpastespecialtranspose -- Don Guillett Microsoft MVP Excel SalesAid Software "ezil" wrote in message ... My task is to copy data from columns for eg. a2 to a10 and paste the values to rows for eg. b2 to k2 of another worksheet. How to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy/Paste with Hidden Rows/Columns Excel 2007 | Excel Discussion (Misc queries) | |||
| Copy & Paste converting rows to columns | Excel Discussion (Misc queries) | |||
| how do i paste rows/columns avoiding hidden rows/columns | Excel Discussion (Misc queries) | |||
| How do I Copy and Paste onto Same Rows after filtering out rows. | Excel Discussion (Misc queries) | |||
| Hide Rows - copy and paste only rows that show | Excel Worksheet Functions | |||
Hybrid Mode
