copy columns paste in rows

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
A clue to help you. Copy the cells in the column>select
destination>edit>pastespecial>transpose
 
Thanks
I have to do this task through a macro. Not directly from excel menu.
 
Turn on the macro recorder and see what you come up with.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

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
Arrays and scattered cell values or another way? 16
Paste in column B using Last row of either column B, C or D. 10
Macro will copy formula instead of value 6
copy/paste: strange feature (I think) 1
loop to copy paste 5
Selecting rows 3
Delete rows takes forever 4

Back
Top