copy columns paste in rows

G

Guest

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?
 
D

Don Guillett

A clue to help you. Copy the cells in the column>select
destination>edit>pastespecial>transpose
 
G

Gord Dibben

Turn on the macro recorder and see what you come up with.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count cells containing text, multiple criteria 2
Delete rows takes forever 4
copy/paste: strange feature (I think) 1
Arrays and scattered cell values or another way? 16
VBA - retrieve data on last create named range from previous inserted named range 0
Selecting rows 3
Array problem 1
How to use OFFSET in VBA 1

Top