do you mean this?

select M162:M166
Edit-Copy (or CTRL+C)
go to C138
Edit-PasteSpecial-select Transpose

etc.

On 19 Sty, 07:59, mickn74 wrote:
Without manually having to enter every cell reference I need ot copy multiple
cells from a column into various rows

Eg : I want to copy
Comunm M : M162:M166 (M168:M172 ...............) etc
to Row 138 : C138, D138, E138, F138, G138
Row 139 : C,D,E,F,G
Row 140 etc

Is there a quick copy and paste method for this

Or do you have to refernce every cell

Regadrs,

Michael

Regadrs,

Mick *