paulfitz320

Board Regular
Joined
Jan 6, 2007
Messages
104
=TRANSPOSE(Arsenal!E5:E27)
=TRANSPOSE(Arsenal!F5:F27)
=TRANSPOSE(Arsenal!F6:F28) <<<<<<<

How can I COPY row 2 and PASTE into row 3 with a cell reference of G5:G27 rather than the (F6:F28) that its doing now.

Thanks
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Watch MrExcel Video

Forum statistics

Threads
1,109,073
Messages
5,526,655
Members
409,713
Latest member
roman9980

This Week's Hot Topics

Top