|
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? |
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? |
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? |
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? |
| All times are GMT +1. The time now is 08:26 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com