copying of cells in multiple worksheets

[coposg]

I have a question I hope someone can answer, the query may be dead simple.
In one worksheet I have a number of values listed vertically, but want to copy these values into another worksheet, but list them horizontally
There are lists of 30 values, so I want to use drag and drop, but if I drag from left to right, the values from the source sheet from left to right are listed, I want the values in the horizontal column, not the row.
Hope this is explained properly, and hope someone can help

Thanks
Steven

 

[PHV]

In the PasteSpecial menu have a look at Transpose.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[GlennUK]

Do Copy, and then where you want the cells to be copied to do Edit/Paste Special and choose the Transpose option.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[coposg]

Thanks very much, that helps me out alot.

 

[GlennUK]

My pleasure

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.