Jarek,

Thanks a heap a new litlle trick, I had to use the Transpose and Values as
it copied the formulas in which gave an incorrect value as the formulas are
looking at different cells. Yet the clicking the Values as well fixed it up

Thanks

Mick

"Jarek Kujawa" wrote:

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