copy columns paste in rows

's Computer Specifications

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?

's Computer Specifications

A clue to help you. Copy the cells in the column>select
destination>edit>pastespecial>transpose
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"ezil" <(E-Mail Removed)> wrote in message
news:5100EDC9-A3CA-470B-9DE7-(E-Mail Removed)...
> 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?

's Computer Specifications

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 column>select
> destination>edit>pastespecial>transpose
> --
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> (E-Mail Removed)
> "ezil" <(E-Mail Removed)> wrote in message
> news:5100EDC9-A3CA-470B-9DE7-(E-Mail Removed)...
> > 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?
>
>

's Computer Specifications

The macro recorder is your friend.
tools>macro>record>>>>
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"ezil" <(E-Mail Removed)> wrote in message
news:11A7014F-D17F-418E-B53D-(E-Mail Removed)...
> 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 column>select
>> destination>edit>pastespecial>transpose
>> --
>> Don Guillett
>> Microsoft MVP Excel
>> SalesAid Software
>> (E-Mail Removed)
>> "ezil" <(E-Mail Removed)> wrote in message
>> news:5100EDC9-A3CA-470B-9DE7-(E-Mail Removed)...
>> > 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?
>>
>>

's Computer Specifications

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 <(E-Mail Removed)> 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 column>select
>> destination>edit>pastespecial>transpose
>> --
>> Don Guillett
>> Microsoft MVP Excel
>> SalesAid Software
>> (E-Mail Removed)
>> "ezil" <(E-Mail Removed)> wrote in message
>> news:5100EDC9-A3CA-470B-9DE7-(E-Mail Removed)...
>> > 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?
>>
>>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
RE: Copy & Paste converting rows to columns	Jacob Skaria	Microsoft Excel Misc	0	10th Dec 2009 06:20 AM
Re: How can I copy/paste just the visible rows/columns in a subtotale.	Ron de Bruin	Microsoft Excel Misc	0	21st Sep 2004 02:27 PM
Re: How can I copy/paste just the visible rows/columns in a subtotale.	Bernie Deitrick	Microsoft Excel Misc	0	21st Sep 2004 02:23 PM
How can I copy/paste just the visible rows/columns in a subtotale.	=?Utf-8?B?anVsZXJvc3M=?=	Microsoft Excel Misc	0	21st Sep 2004 02:15 PM
copy paste only visible rows and columns	Alain	Microsoft Excel Discussion	5	8th Mar 2004 12:40 PM