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?